VIEW: APPS.PAY_IE_P45_ADDRESS_DETAILS

Source

View Text - Preformatted

SELECT /*+ USE_NL(PPA PAA) */ PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID ,SUBSTR(PAI_ADD.ACTION_INFORMATION5, 1,30) ADDRESS1 ,SUBSTR(PAI_ADD.ACTION_INFORMATION6, 1,30) ADDRESS2 ,SUBSTR(PAI_ADD.ACTION_INFORMATION7, 1,30) ADDRESS3 ,PAY_IE_P45_ARCHIVE.GET_LOOKUP_MEANING('IE_COUNTY',SUBSTR(PAI_ADD.ACTION_INFORMATION9, 1,30)) COUNTY ,PAY_IE_P45_ARCHIVE.GET_LOOKUP_MEANING('IE_POSTAL_CODE',SUBSTR(PAI_ADD.ACTION_INFORMATION12, 1,30)) POST_CODE ,NULL PHONE_NO FROM PAY_PAYROLL_ACTIONS PPA ,PAY_ASSIGNMENT_ACTIONS PAA ,PAY_ACTION_INFORMATION PAI_ADD WHERE PPA.REPORT_TYPE = 'P45' AND PPA.REPORT_QUALIFIER = 'IE' AND PPA.REPORT_CATEGORY = 'ARCHIVE' AND PPA.ACTION_STATUS = 'C' AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PAA.ASSIGNMENT_ACTION_ID = PAI_ADD.ACTION_CONTEXT_ID AND PAI_ADD.ACTION_CONTEXT_TYPE = 'AAP' AND PAI_ADD.ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'

View Text - HTML Formatted

SELECT /*+ USE_NL(PPA PAA) */ PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(PAI_ADD.ACTION_INFORMATION5
, 1
, 30) ADDRESS1
, SUBSTR(PAI_ADD.ACTION_INFORMATION6
, 1
, 30) ADDRESS2
, SUBSTR(PAI_ADD.ACTION_INFORMATION7
, 1
, 30) ADDRESS3
, PAY_IE_P45_ARCHIVE.GET_LOOKUP_MEANING('IE_COUNTY'
, SUBSTR(PAI_ADD.ACTION_INFORMATION9
, 1
, 30)) COUNTY
, PAY_IE_P45_ARCHIVE.GET_LOOKUP_MEANING('IE_POSTAL_CODE'
, SUBSTR(PAI_ADD.ACTION_INFORMATION12
, 1
, 30)) POST_CODE
, NULL PHONE_NO
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INFORMATION PAI_ADD
WHERE PPA.REPORT_TYPE = 'P45'
AND PPA.REPORT_QUALIFIER = 'IE'
AND PPA.REPORT_CATEGORY = 'ARCHIVE'
AND PPA.ACTION_STATUS = 'C'
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = PAI_ADD.ACTION_CONTEXT_ID
AND PAI_ADD.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_ADD.ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'