Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_IE_SOCIAL_BENEFITS_V |
SELECT PSB.ROWID
, PSB.SOCIAL_BENEFIT_ID
, PSB.EFFECTIVE_START_DATE
, PSB.EFFECTIVE_END_DATE
, PSB.OBJECT_VERSION_NUMBER
, PSB.ASSIGNMENT_ID
, PSB.ABSENCE_START_DATE
, PSB.ABSENCE_END_DATE
, PSB.BENEFIT_AMOUNT
, PSB.BENEFIT_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_BENEFIT_TYPE'
, PSB.BENEFIT_TYPE)
, 1
, 80) D_BENEFIT_TYPE
, PSB.CALCULATION_OPTION
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_CALC_OPTION'
, PSB.CALCULATION_OPTION)
, 1
, 80) D_CALCULATION_OPTION
, PSB.REDUCED_TAX_CREDIT
, PSB.REDUCED_STANDARD_CUTOFF
, PSB.INCIDENT_ID
, PWI.INCIDENT_REFERENCE
, PWI.INCIDENT_DATE
, PWI.INCIDENT_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('INCIDENT_TYPE'
, PWI.INCIDENT_TYPE)
, 1
, 80) D_INCIDENT_TYPE
, PSB.CREATED_BY
, PSB.CREATION_DATE
, PSB.LAST_UPDATED_BY
, PSB.LAST_UPDATE_DATE
, PSB.LAST_UPDATE_LOGIN
, PSB.REQUEST_ID
, PSB.PROGRAM_APPLICATION_ID
, PSB.PROGRAM_ID
, PSB.PROGRAM_UPDATE_DATE
FROM PAY_IE_SOCIAL_BENEFITS_F PSB
, FND_SESSIONS FS
, PER_WORK_INCIDENTS PWI
WHERE FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PSB.EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
AND PSB.INCIDENT_ID = PWI.INCIDENT_ID (+)