DBA Data[Home] [Help]

APPS.PAY_DK_EMP_TRAINEE_REIMBURSE dependencies on PER_ALL_PEOPLE_F

Line 149: FROM PER_ALL_PEOPLE_F PAP

145: /* CURSOR C1(QUARTER_START DATE, QUARTER_END DATE)
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

Line 202: FROM PER_ALL_PEOPLE_F PAP

198: SELECT ASG.PERSON_ID, ASG.ASSIGNMENT_ID, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID,
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