APPS.PER_PERUSE1L_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 153: PER_ASSIGNMENTS_F ASS,

149: /* Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL
150: with PER_JOBS - bug#11736960 */
151: --PER_PEOPLE_F PEO
152: PER_ALL_PEOPLE_F PEO,
153: PER_ASSIGNMENTS_F ASS,
154: --PER_JOBS_VL JOB,
155: PER_JOBS JOB,
156: HR_LOCATIONS_ALL HL
157: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 185: PER_ASSIGNMENTS_F ASS1,

181: AND ASS.EFFECTIVE_START_DATE = (
182: SELECT
183: MAX(ASS1.EFFECTIVE_START_DATE)
184: FROM
185: PER_ASSIGNMENTS_F ASS1,
186: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
187: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
188: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
189: AND ASS.PERSON_ID = ASS1.PERSON_ID

Line 297: PER_ASSIGNMENTS_F ASS,

293: FROM
294: --Replaced PER_PEOPLE_F with PER_ALL_PEOPLE_F and PER_JOBS_VL with PER_JOBS
295: --PER_PEOPLE_F PEO,
296: PER_ALL_PEOPLE_F PEO,
297: PER_ASSIGNMENTS_F ASS,
298: --PER_JOBS_VL JOB
299: PER_JOBS JOB
300: WHERE PEO.PERSON_ID = ASS.PERSON_ID
301: --

Line 327: PER_ASSIGNMENTS_F ASS1,

323: AND ASS.EFFECTIVE_START_DATE = (
324: SELECT
325: MAX(ASS1.EFFECTIVE_START_DATE)
326: FROM
327: PER_ASSIGNMENTS_F ASS1,
328: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
329: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
330: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
331: AND ASS.PERSON_ID = ASS1.PERSON_ID

Line 416: PER_ASSIGNMENTS_F ASS,

412: SELECT
413: COUNT('X')
414: INTO L_COUNT_EMPS
415: FROM
416: PER_ASSIGNMENTS_F ASS,
417: --Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
418: --PER_JOBS_VL JOB
419: PER_JOBS JOB
420: WHERE JOB.JOB_INFORMATION_CATEGORY = 'US'

Line 466: PER_ASSIGNMENTS_F ASS1,

462: AND ASS.EFFECTIVE_START_DATE = (
463: SELECT
464: MAX(ASS1.EFFECTIVE_START_DATE)
465: FROM
466: PER_ASSIGNMENTS_F ASS1,
467: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
468: WHERE L_DATE_START <= ASS1.EFFECTIVE_END_DATE
469: AND L_DATE_END >= ASS1.EFFECTIVE_START_DATE
470: AND ASS.PERSON_ID = ASS1.PERSON_ID