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 ,ppd.usc_info_source ,substr(hr_general.decode_lookup('IE_PAYE_INFO_SOURCE' ,ppd.USC_INFO_SOURCE) ,1 ,80) d_usc_info_source ,ppd.usc_tax_basis ,substr(hr_general.decode_lookup('IE_PAYE_TAX_BASIS' ,ppd.usc_tax_basis) ,1 ,80) d_usc_tax_basis ,ppd.USC_RATE_1 ,ppd.USC_RATE_2 ,ppd.USC_RATE_3 ,ppd.USC_MTHLY_CUTOFF_1 ,ppd.USC_MTHLY_CUTOFF_2 ,ppd.USC_WKLY_CUTOFF_1 ,ppd.USC_WKLY_CUTOFF_2 ,ppd.YRLY_TAX_CRED ,ppd.YRLY_TAX_RATE_1 ,ppd.YRLY_TAX_RATE_2 ,ppd.MTHLY_TAX_RATE_2 ,ppd.WKLY_TAX_RATE_2 ,ppd.TAX_RATE_3 ,ppd.YRLY_TAX_RATE_3 ,ppd.MTHLY_TAX_RATE_3 ,ppd.WKLY_TAX_RATE_3 ,ppd.TAX_RATE_4 ,ppd.YRLY_TAX_RATE_4 ,ppd.MTHLY_TAX_RATE_4 ,ppd.WKLY_TAX_RATE_4 ,ppd.TAX_RATE_5 ,ppd.IN_EXEMPT_USC ,ppd.USC_YRLY_CUTOFF_1 ,ppd.USC_YRLY_CUTOFF_2 ,ppd.USC_YRLY_CUTOFF_3 ,ppd.USC_MTHLY_CUTOFF_3 ,ppd.USC_WKLY_CUTOFF_3 ,ppd.USC_RATE_4 ,ppd.USC_YRLY_CUTOFF_4 ,ppd.USC_MTHLY_CUTOFF_4 ,ppd.USC_WKLY_CUTOFF_4 ,ppd.USC_RATE_5 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
, PPD.USC_INFO_SOURCE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PAYE_INFO_SOURCE'
, PPD.USC_INFO_SOURCE)
, 1
, 80) D_USC_INFO_SOURCE
, PPD.USC_TAX_BASIS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('IE_PAYE_TAX_BASIS'
, PPD.USC_TAX_BASIS)
, 1
, 80) D_USC_TAX_BASIS
, PPD.USC_RATE_1
, PPD.USC_RATE_2
, PPD.USC_RATE_3
, PPD.USC_MTHLY_CUTOFF_1
, PPD.USC_MTHLY_CUTOFF_2
, PPD.USC_WKLY_CUTOFF_1
, PPD.USC_WKLY_CUTOFF_2
, PPD.YRLY_TAX_CRED
, PPD.YRLY_TAX_RATE_1
, PPD.YRLY_TAX_RATE_2
, PPD.MTHLY_TAX_RATE_2
, PPD.WKLY_TAX_RATE_2
, PPD.TAX_RATE_3
, PPD.YRLY_TAX_RATE_3
, PPD.MTHLY_TAX_RATE_3
, PPD.WKLY_TAX_RATE_3
, PPD.TAX_RATE_4
, PPD.YRLY_TAX_RATE_4
, PPD.MTHLY_TAX_RATE_4
, PPD.WKLY_TAX_RATE_4
, PPD.TAX_RATE_5
, PPD.IN_EXEMPT_USC
, PPD.USC_YRLY_CUTOFF_1
, PPD.USC_YRLY_CUTOFF_2
, PPD.USC_YRLY_CUTOFF_3
, PPD.USC_MTHLY_CUTOFF_3
, PPD.USC_WKLY_CUTOFF_3
, PPD.USC_RATE_4
, PPD.USC_YRLY_CUTOFF_4
, PPD.USC_MTHLY_CUTOFF_4
, PPD.USC_WKLY_CUTOFF_4
, PPD.USC_RATE_5
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