View: PER_HU_EMPLOYMENT_CERT_V

Product:	PER - Human Resources
Description:	View is used in Employment Certificate Web ADI Report.
Implementation/DBA Data:	APPS.PER_HU_EMPLOYMENT_CERT_V

View Text

SELECT PPA.PAYROLL_ACTION_ID
, PPA.REQUEST_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAI1.ACTION_INFORMATION1 ORGANIZATION_ID
, PAI1.ACTION_INFORMATION5 EMPLOYER_LOCATION_NAME
, PAI1.ACTION_INFORMATION6 EMPLOYER_LOCATION_TYPE
, PAI1.ACTION_INFORMATION7 EMPLOYER_STREET_NO
, PAI1.ACTION_INFORMATION8 EMPLOYER_TOWN
, PAI1.ACTION_INFORMATION13 EMPLOYER_COUNTY
, PAI1.ACTION_INFORMATION12 EMPLOYER_POSTAL_CODE
, PAI1.ACTION_INFORMATION26 EMPLOYER_BUILDING
, PAI1.ACTION_INFORMATION27 EMPLOYER_STAIRWAY
, PAI1.ACTION_INFORMATION28 EMPLOYER_FLOOR
, PAI1.ACTION_INFORMATION29 EMPLOYER_DOOR
, PAI2.ACTION_INFORMATION1 PERSON_ID
, PAI2.ACTION_INFORMATION5 COMPANY_NAME
, PAI2.ACTION_INFORMATION6 FULL_NAME
, PAI2.ACTION_INFORMATION7 MAIDEN_NAME
, PAI2.ACTION_INFORMATION8 TAJ_CODE
, PAI2.ACTION_INFORMATION9 PLACE_OF_BIRTH
, PAI2.ACTION_INFORMATION10 DATE_OF_BIRTH
, PAI2.ACTION_INFORMATION11 MOTHER_MAIDEN_NAME
, PAI2.ACTION_INFORMATION12 HIRE_DATE
, PAI2.ACTION_INFORMATION13 TERMINATION_DATE
, PAI2.ACTION_INFORMATION14 SICKNESS_HOLIDAY
, PAI2.ACTION_INFORMATION15 RAILWAY_BENEFIT
, PAI2.ACTION_INFORMATION16 PENSION_FUND_DATE_OF_ENTRANCE
, PAI2.ACTION_INFORMATION17 PRIVATE_PENSION_FUND_CODE
, PAI2.ACTION_INFORMATION18 PRIVATE_PENSION_FUND_NAME
, PAI2.ACTION_INFORMATION19 PRIVATE_PENSION_FUND_ADDRESS
, PAI2.ACTION_INFORMATION20 PRIVATE_PENSION_FUND_ACC_NO
, PAI2.ACTION_INFORMATION21 VOLUNTARY_PENSION_FUND_NAME1
, PAI2.ACTION_INFORMATION22 VOLUNTARY_PENSION_FUND_NAME2
, PAI2.ACTION_INFORMATION23 VOLUNTARY_PENSION_FUND_NAME3
, PAI2.ACTION_INFORMATION24 VOLUNTARY_PENSION_FUND_NAME4
, PAI2.ACTION_INFORMATION25 VOLUNTARY_PENSION_FUND_NAME5
, PAI2.ACTION_INFORMATION26 ISSUE_DATE
, PAI3.ACTION_INFORMATION5 EMPLOYEE_LOCATION_NAME
, PAI3.ACTION_INFORMATION6 EMPLOYEE_LOCATION_TYPE
, PAI3.ACTION_INFORMATION7 EMPLOYEE_STREET_NO
, PAI3.ACTION_INFORMATION8 EMPLOYEE_TOWN
, PAI3.ACTION_INFORMATION12 EMPLOYEE_POSTAL_CODE
, PAI3.ACTION_INFORMATION26 EMPLOYEE_BUILDING
, PAI3.ACTION_INFORMATION27 EMPLOYEE_STAIRWAY
, PAI3.ACTION_INFORMATION28 EMPLOYEE_FLOOR
, PAI3.ACTION_INFORMATION29 EMPLOYEE_DOOR
, ' ' SETTLEMENT_PAID
FROM PAY_ACTION_INFORMATION PAI1
, PAY_ACTION_INFORMATION PAI2
, PAY_ACTION_INFORMATION PAI3
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAI1.ACTION_CONTEXT_ID
AND PAA.ASSIGNMENT_ACTION_ID = PAI2.ACTION_CONTEXT_ID
AND PAI2.ACTION_CONTEXT_ID = PAI3.ACTION_CONTEXT_ID (+)
AND PAI1.ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'
AND PAI1.ACTION_CONTEXT_TYPE = 'PA'
AND PAI2.ACTION_INFORMATION_CATEGORY = 'HU_EMP_CERTIFICATION'
AND PAI2.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI3.ACTION_INFORMATION_CATEGORY(+) = 'ADDRESS DETAILS'
AND PAI3.ACTION_CONTEXT_TYPE(+) = 'AAP'
AND PAI1.ACTION_INFORMATION1 = PAI2.ACTION_INFORMATION2
AND PAI2.ACTION_INFORMATION1 = PAI3.ACTION_INFORMATION1(+)
AND PAI1.ACTION_INFORMATION14 = 'EMPLOYER'
AND PAI3.ACTION_INFORMATION14(+)= 'EMPLOYEE'

Columns