Product: | PAY - Payroll |
---|---|
Description: | This view returns employee assignment which are target for Separation Pay Process. |
Implementation/DBA Data: | APPS.PAY_KR_SEP_MASTER_V |
SELECT PP.PERSON_ID PERSON_ID
, PP.EFFECTIVE_START_DATE PEFFECTIVE_START_DATE
, PP.EFFECTIVE_END_DATE PEFFECTIVE_END_DATE
, PP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PAY_KR_REPORT_PKG.LEGISLATION_CODE(PP.BUSINESS_GROUP_ID) LEGISLATION_CODE
, PP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PP.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, PP.FULL_NAME FULL_NAME
, PPT.PERSON_TYPE_ID PERSON_TYPE_ID
, PPT.SYSTEM_PERSON_TYPE SYSTEM_PERSON_TYPE
, PA.ASSIGNMENT_ID ASSIGNMENT_ID
, PA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PA.ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, PA.PAYROLL_ID PAYROLL_ID
, PA.EFFECTIVE_START_DATE AEFFECTIVE_START_DATE
, PA.EFFECTIVE_END_DATE AEFFECTIVE_END_DATE
, PA.ESTABLISHMENT_ID ESTABLISHMENT_ID
, HOU.NAME ORGANIZATION_NAME
, SUBSTR(RTRIM(REPLACE(HOI.ORG_INFORMATION2
, '-'
, ''))
, 1
, 10) BP_NUMBER
, SUBSTR(RTRIM(HOI.ORG_INFORMATION1)
, 1
, 40) BP_NAME
, PPOS.PERIOD_OF_SERVICE_ID PERIOD_OF_SERVICE_ID
, PPOS.ACTUAL_TERMINATION_DATE ACTUAL_TERMINATION_DATE
, PPOS.FINAL_PROCESS_DATE FINAL_PROCESS_DATE
FROM HR_ORGANIZATION_INFORMATION HOI
, HR_ORGANIZATION_UNITS HOU
, PER_PERIODS_OF_SERVICE PPOS
, PER_ASSIGNMENTS_F PA
, PER_PERSON_TYPES PPT
, PER_PEOPLE_F PP
WHERE PPT.PERSON_TYPE_ID = PP.PERSON_TYPE_ID
AND PPOS.PERSON_ID = PP.PERSON_ID
AND PPOS.PERSON_ID = PA.PERSON_ID
AND HOU.ORGANIZATION_ID (+) = PA.ORGANIZATION_ID
AND HOI.ORGANIZATION_ID (+) = PA.ESTABLISHMENT_ID
AND HOI.ORG_INFORMATION_CONTEXT (+) = 'KR_BUSINESS_PLACE_REGISTRATION'
AND PPOS.PERIOD_OF_SERVICE_ID = PA.PERIOD_OF_SERVICE_ID