DBA Data[Home] [Help]

APPS.PAY_DK_EMP_TRAINEE_REIMBURSE dependencies on PER_ALL_ASSIGNMENTS_F

Line 150: ,PER_ALL_ASSIGNMENTS_F ASG

146: IS
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

Line 155: ,PER_ALL_ASSIGNMENTS_F PASG

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
156: WHERE PAP.PERSON_ID = ASG.PERSON_ID
157: AND ASG.PAYROLL_ID = PPA.PAYROLL_ID
158: AND ASG.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
159: AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID

Line 203: ,PER_ALL_ASSIGNMENTS_F ASG

199: PPA.PAYROLL_ID, PPA.DATE_EARNED EFFECTIVE_DATE, PAP.PER_INFORMATION3,
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