VIEW: APPS.PAY_IE_PAYE_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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