DBA Data[Home] [Help]

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_JOBS_VL

Line 319: PER_JOBS_VL JOB

315: INTO L_COUNT_EMPS
316: FROM
317: PER_ALL_ASSIGNMENTS_F ASS,
318: PER_ALL_PEOPLE_F PEO,
319: PER_JOBS_VL JOB
320: WHERE PEO.PERSON_ID = ASS.PERSON_ID
321: AND PEO.PER_INFORMATION1 is not NULL
322: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
323: AND P_PAYROLL_PERIOD_DATE_START_T <= NVL(JOB.DATE_TO

Line 493: PER_JOBS_VL JOB

489: INTO CP_HW_CAT,CP_HW_MALE,CP_HW_FEMALE
490: FROM
491: PER_ALL_PEOPLE_F PEO,
492: PER_ALL_ASSIGNMENTS_F ASS,
493: PER_JOBS_VL JOB
494: WHERE PEO.PERSON_ID = ASS.PERSON_ID
495: AND PEO.PER_INFORMATION1 is not NULL
496: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
497: AND P_PAYROLL_PERIOD_DATE_START_T <= NVL(JOB.DATE_TO

Line 609: PER_JOBS_VL JOB

605: INTO L_COUNT_EMPS
606: FROM
607: PER_ALL_ASSIGNMENTS_F ASS,
608: PER_ALL_PEOPLE_F PEO,
609: PER_JOBS_VL JOB
610: WHERE PEO.PERSON_ID = ASS.PERSON_ID
611: AND PEO.PER_INFORMATION1 is not NULL
612: AND JOB.JOB_INFORMATION_CATEGORY = 'US'
613: AND P_PAYROLL_PERIOD_DATE_START_T <= NVL(JOB.DATE_TO

Line 856: PER_JOBS_VL JOB,

852: ASS.JOB_ID
853: FROM
854: PER_ALL_PEOPLE_F PEO,
855: PER_ALL_ASSIGNMENTS_F ASS,
856: PER_JOBS_VL JOB,
857: HR_LOCATIONS_ALL HL
858: WHERE PEO.PERSON_ID = ASS.PERSON_ID
859: AND PEO.PER_INFORMATION1 is not null
860: AND PEO.PER_INFORMATION_CATEGORY = 'US'