VIEW: APPS.PAY_IE_PRSI_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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