Product: | PAY - Payroll |
---|---|
Description: | Used to support User Interface. It is based on PAY_IE_PAYE_DETAILS_F |
Implementation/DBA Data: | APPS.PAY_IE_PAYE_DETAILS_V |
SELECT PPD.ROWID ROW_ID
, PPD.PAYE_DETAILS_ID
, PPD.EFFECTIVE_START_DATE
, PPD.EFFECTIVE_END_DATE
, PPD.OBJECT_VERSION_NUMBER
, PPD.INFO_SOURCE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PAYE_INFO_SOURCE'
, PPD.INFO_SOURCE)
, 1
, 80) D_INFO_SOURCE
, PPD.COMM_PERIOD_NO
, PPD.TAX_BASIS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PAYE_TAX_BASIS'
, PPD.TAX_BASIS)
, 1
, 80) D_TAX_BASIS
, PPD. WEEKLY_TAX_CREDIT
, PPD.MONTHLY_TAX_CREDIT
, PPD.WEEKLY_STD_RATE_CUT_OFF
, PPD.MONTHLY_STD_RATE_CUT_OFF
, PPD.CERTIFICATE_START_DATE
, PPD.CERTIFICATE_END_DATE
, PPD.TAX_ASSESS_BASIS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PAYE_ASSESS_BASIS'
, PPD.TAX_ASSESS_BASIS)
, 1
, 80) D_TAX_ASSESS_BASIS
, 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.CERTIFICATE_ISSUE_DATE
FROM PAY_IE_PAYE_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