VIEW: APPS.PAY_IE_P45_SOC_BEN_DETAILS

Source

View Text - Preformatted

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID ,pay_ie_p45_archive.get_arc_bal_value(paa.assignment_action_id, paa.payroll_action_id,'IE Illness Benefit') DISABILITY_BENEFIT ,pay_ie_p45_archive.get_arc_bal_value(paa.assignment_action_id,paa.payroll_action_id, 'IE Reduced Tax Credit') RED_TAX_CREDIT ,pay_ie_p45_archive.get_arc_bal_value(paa.assignment_action_id,paa.payroll_action_id, 'IE Reduced Std Rate Cut Off') RED_STD_CUT_OFF ,SUBSTR(PAI_IEP45.ACTION_INFORMATION6,1,10) NON_CUMMULATIVE_BASIS FROM PAY_PAYROLL_ACTIONS PPA ,PAY_ASSIGNMENT_ACTIONS PAA ,PAY_ACTION_INFORMATION PAI_IEP45 WHERE PAA.ASSIGNMENT_ACTION_ID = PAI_IEP45.ACTION_CONTEXT_ID AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PPA.EFFECTIVE_DATE = PAI_IEP45.EFFECTIVE_DATE AND PPA.REPORT_TYPE = 'P45' AND PPA.REPORT_QUALIFIER = 'IE' AND PPA.REPORT_CATEGORY = 'ARCHIVE' AND PPA.ACTION_STATUS = 'C' AND PAI_IEP45.ACTION_CONTEXT_TYPE = 'AAP' AND PAI_IEP45.ACTION_INFORMATION_CATEGORY = 'IE P45 INFORMATION'

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAY_IE_P45_ARCHIVE.GET_ARC_BAL_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PAA.PAYROLL_ACTION_ID
, 'IE ILLNESS BENEFIT') DISABILITY_BENEFIT
, PAY_IE_P45_ARCHIVE.GET_ARC_BAL_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PAA.PAYROLL_ACTION_ID
, 'IE REDUCED TAX CREDIT') RED_TAX_CREDIT
, PAY_IE_P45_ARCHIVE.GET_ARC_BAL_VALUE(PAA.ASSIGNMENT_ACTION_ID
, PAA.PAYROLL_ACTION_ID
, 'IE REDUCED STD RATE CUT OFF') RED_STD_CUT_OFF
, SUBSTR(PAI_IEP45.ACTION_INFORMATION6
, 1
, 10) NON_CUMMULATIVE_BASIS
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INFORMATION PAI_IEP45
WHERE PAA.ASSIGNMENT_ACTION_ID = PAI_IEP45.ACTION_CONTEXT_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE = PAI_IEP45.EFFECTIVE_DATE
AND PPA.REPORT_TYPE = 'P45'
AND PPA.REPORT_QUALIFIER = 'IE'
AND PPA.REPORT_CATEGORY = 'ARCHIVE'
AND PPA.ACTION_STATUS = 'C'
AND PAI_IEP45.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_IEP45.ACTION_INFORMATION_CATEGORY = 'IE P45 INFORMATION'