View: PAY_IE_P45_EMPLOYEE_DETAILS

Product:	PAY - Payroll
Description:	Used by IE P45 Form
Implementation/DBA Data:	APPS.PAY_IE_P45_EMPLOYEE_DETAILS

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PAI_IEED.ACTION_INFORMATION29 LAST_NAME
, PAI_IEED.ACTION_INFORMATION28 FIRST_NAME
, PAI_ED.ACTION_INFORMATION4 PPS_NO
, TO_DATE(PAI_IEED.ACTION_INFORMATION25
, 'DD-MON-RRRR') DATE_OF_BIRTH
, PAI_ED.ACTION_INFORMATION14 WORKS_NO
, TO_DATE(PAI_IEP45.ACTION_INFORMATION3
, 'DD-MON-RRRR') DATE_OF_LEAVING
, TO_DATE (DECODE (SIGN ( TO_DATE ( LEG.RULE_MODE || TO_CHAR (PACT.EFFECTIVE_DATE
, 'YYYY')
, 'DD/MM/YYYY' ) - DECODE (LENGTH (PAI_IEED.ACTION_INFORMATION30)
, 19
, FND_DATE.CANONICAL_TO_DATE (PAI_IEED.ACTION_INFORMATION30)
, FND_DATE.DISPLAYDATE_TO_DATE (PAI_IEED.ACTION_INFORMATION30) ) )
, 1
, NULL
, DECODE (LENGTH (PAI_IEED.ACTION_INFORMATION30)
, 19
, FND_DATE.CANONICAL_TO_DATE (PAI_IEED.ACTION_INFORMATION30)
, FND_DATE.DISPLAYDATE_TO_DATE (PAI_IEED.ACTION_INFORMATION30) ) )
, 'DD-MON-RRRR' ) DATE_OF_COMMENCEMENT
, PAI_IEP45.ACTION_INFORMATION1 DECEASED
, PAI_IEP45.ACTION_INFORMATION8 PERSON_ID
, PAA.TAX_UNIT_ID TAX_UNIT_ID
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INFORMATION PAI_ED
, PAY_ACTION_INFORMATION PAI_IEED
, PAY_ACTION_INFORMATION PAI_IEP45
, PAY_LEGISLATION_RULES LEG
, PAY_PAYROLL_ACTIONS PACT
WHERE PAA.ASSIGNMENT_ACTION_ID = PAI_ED.ACTION_CONTEXT_ID
AND PAI_ED.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_ED.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS'
AND PAA.ASSIGNMENT_ACTION_ID = PAI_IEED.ACTION_CONTEXT_ID
AND PAI_IEED.ACTION_INFORMATION_CATEGORY = 'IE EMPLOYEE DETAILS'
AND PAI_IEED.ACTION_CONTEXT_TYPE = 'AAP'
AND PAA.ASSIGNMENT_ACTION_ID = PAI_IEP45.ACTION_CONTEXT_ID
AND PAI_IEP45.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_IEP45.ACTION_INFORMATION_CATEGORY = 'IE P45 INFORMATION'
AND LEG.LEGISLATION_CODE='IE'
AND LEG.RULE_TYPE='L'
AND PAA.PAYROLL_ACTION_ID=PACT.PAYROLL_ACTION_ID

Columns