Product: | PAY - Payroll |
---|---|
Description: | Used to support User Interface. It is based on PAY_IE_PRSI_DETAILS_F |
Implementation/DBA Data: | APPS.PAY_IE_PRSI_DETAILS_V |
SELECT PPD.ROWID ROW_ID
, PPD.PRSI_DETAILS_ID
, PPD.EFFECTIVE_START_DATE
, PPD.EFFECTIVE_END_DATE
, PPD.OBJECT_VERSION_NUMBER
, PPD.CONTRIBUTION_CLASS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PRSI_CONT_CLASS'
, PPD.CONTRIBUTION_CLASS)
, 1
, 80) D_CONTRIBUTION_CLASS
, PPD.OVERRIDDEN_SUBCLASS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PRSI_CONT_SUBCLASS'
, PPD.OVERRIDDEN_SUBCLASS)
, 1
, 80) D_OVERRIDDEN_SUBCLASS
, PPD.SOC_BEN_FLAG
, PPD.SOC_BEN_START_DATE
, PPD.OVERRIDDEN_INS_WEEKS
, PPD.NON_STANDARD_INS_WEEKS
, PPD.EXEMPTION_START_DATE
, PPD.EXEMPTION_END_DATE
, PPD.CERT_ISSUED_BY
, PPD.DIRECTOR_FLAG
, PPD.CREATED_BY
, PPD.CREATION_DATE
, PPD.LAST_UPDATED_BY
, PPD.LAST_UPDATE_DATE
, PPD.LAST_UPDATE_LOGIN
, PPD.REQUEST_ID
, PPD.PROGRAM_APPLICATION_ID
, PPD.PROGRAM_ID
, PPD.PROGRAM_UPDATE_DATE
, PPD.ASSIGNMENT_ID
, PPD.COMMUNITY_FLAG
FROM PAY_IE_PRSI_DETAILS_F PPD
, FND_SESSIONS SES
WHERE SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PPD.EFFECTIVE_START_DATE
AND PPD.EFFECTIVE_END_DATE