Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

RESOLVED: Data Model not accepting CASE statement

edited Aug 5, 2022 8:25PM in Payroll for NA / Time and Labor - PSFT (MOSC) 1 commentAnswered

RESOLVED (LOOK AT THE COMMENTS): Using SQLConnect, I can get this section of code to run just fine and return the expected results (which is a monetary, Year-To-Date value)... (of course, I'm omitting the rest of the query for purposes of simplicity because I've already narrowed this CASE statement as the problem-child):

,CASE 

  WHEN PPOS.DATE_START > (SELECT MIN(ptp_1.START_DATE) FROM PAY_TIME_PERIODS PTP_1 WHERE PTP_1.PERIOD_NAME LIKE '1 ' || :FourDigitCurrentYear || ' Biweekly')

  THEN ROUND((ROUND(:MonthBeginDate - PPOS.DATE_START,2) / 365 ),2) * CS.ANNUAL_SALARY * PCAA.PROPORTION

  WHEN PPOS.DATE_START <= (SELECT MIN(ptp_1.START_DATE) FROM PAY_TIME_PERIODS PTP_1 WHERE PTP_1.PERIOD_NAME LIKE '1 ' || :FourDigitCurrentYear || ' Biweekly')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center