DBA Data[Home] [Help]

APPS.PAY_DK_EMP_TRAINEE_REIMBURSE dependencies on PAY_PAYROLL_ACTIONS

Line 151: ,PAY_PAYROLL_ACTIONS PPA

147: SELECT PASG.PERSON_ID, PASG.ASSIGNMENT_ID, MAX(PAA.ASSIGNMENT_ACTION_ID) AS ASSIGNMENT_ACTION_ID,
148: PPA.PAYROLL_ID, MAX(PPA.DATE_EARNED) AS EFFECTIVE_DATE, PAP.PER_INFORMATION3
149: FROM PER_ALL_PEOPLE_F PAP
150: ,PER_ALL_ASSIGNMENTS_F ASG
151: ,PAY_PAYROLL_ACTIONS PPA
152: ,PAY_ASSIGNMENT_ACTIONS PAA
153: ,PAY_RUN_RESULTS PRR
154: ,PAY_ELEMENT_TYPES_F PET
155: ,PER_ALL_ASSIGNMENTS_F PASG

Line 204: ,PAY_PAYROLL_ACTIONS PPA

200: PAP.EFFECTIVE_START_DATE,
201: PAP.EFFECTIVE_END_DATE
202: FROM PER_ALL_PEOPLE_F PAP
203: ,PER_ALL_ASSIGNMENTS_F ASG
204: ,PAY_PAYROLL_ACTIONS PPA
205: ,PAY_ASSIGNMENT_ACTIONS PAA
206: ,PAY_RUN_RESULTS PRR
207: ,PAY_ELEMENT_TYPES_F PET
208: WHERE PAP.PERSON_ID = ASG.PERSON_ID