View: PAY_KR_ASG_ACTIONS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_KR_ASG_ACTIONS_V

View Text

SELECT PPAC.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAC.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID_PAYROLL
, PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID_PAYROLL
, PAP.FIRST_NAME FIRST_NAME
, PAP.LAST_NAME LAST_NAME
, PAP.ORDER_NAME ORDER_NAME
, PAP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PAA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PAY.PAYROLL_ID PAYROLL_ID
, PAY.PAYROLL_NAME PAYROLL_NAME
, PRT.RUN_TYPE_NAME RUN_TYPE_NAME
, PAP.START_DATE HIRE_DATE
, PPA.EFFECTIVE_DATE PAID_DATE
, PTP.START_DATE START_DATE
, PTP.END_DATE END_DATE
, HOI.ORGANIZATION_ID ORGANIZATION_ID
, HOI.ORG_INFORMATION1 ESTABLISHMENT_NAME
, PGT.NAME GRADE
, PKG.GRADE_NAME KR_GRADE
FROM PAY_PAYROLLS_F PAY
, PAY_PAYROLL_ACTIONS PPA
, PAY_PAYROLL_ACTIONS PPPA
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_ASSIGNMENT_ACTIONS PPAC
, PER_ASSIGNMENTS_F PAA
, PER_PEOPLE_F PAP
, PER_GRADES_TL PGT
, PER_KR_GRADES PKG
, HR_ORGANIZATION_INFORMATION HOI
, PAY_RUN_TYPES_F PRT
, PER_TIME_PERIODS PTP
, ( SELECT LOCKING_ACTION_ID LOCKING_ACTION_ID
, MAX(LOCKED_ACTION_ID) LOCKED_ACTION_ID
FROM PAY_ACTION_INTERLOCKS GROUP BY LOCKING_ACTION_ID ) PAI
WHERE PAY.PAYROLL_ID = PPA.PAYROLL_ID
AND PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ID = PAC.ASSIGNMENT_ID
AND PAP.PERSON_ID = PAA.PERSON_ID
AND PPA.ACTION_STATUS = 'C'
AND PPA.ACTION_TYPE IN ('R'
, 'Q')
AND PPPA.PAYROLL_ACTION_ID = PPAC.PAYROLL_ACTION_ID
AND PPPA.ACTION_STATUS = 'C'
AND PPPA.ACTION_TYPE IN ('P'
, 'U')
AND PAA.GRADE_ID = PGT.GRADE_ID(+)
AND PGT.LANGUAGE (+) = USERENV('LANG')
AND PAA.GRADE_ID = PKG.GRADE_ID(+)
AND PAC.TAX_UNIT_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'KR_BUSINESS_PLACE_REGISTRATION'
AND PRT.RUN_TYPE_ID = PAC.RUN_TYPE_ID
AND PTP.PAYROLL_ID = PAY.PAYROLL_ID
AND PAC.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND PPAC.ASSIGNMENT_ACTION_ID= PAI.LOCKING_ACTION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE

Columns