APPS.PQH_PQIPED8_XMLP_PKG dependencies on PER_JOBS

Line 405: PER_JOBS JOB

401: PER_PEOPLE_EXTRA_INFO PPET,
402: HR_LOOKUPS HL,
403: PER_PAY_PROPOSALS PPP,
404: PER_PAY_BASES PPB,
405: PER_JOBS JOB
406: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
407: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
408: AND PAF.PERSON_ID = PPET.PERSON_ID
409: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 578: PER_JOBS JOB,

574: PER_PEOPLE_EXTRA_INFO PPET,
575: HR_LOOKUPS HL,
576: PER_PAY_PROPOSALS PPP,
577: PER_PAY_BASES PPB,
578: PER_JOBS JOB,
579: PER_PEOPLE_EXTRA_INFO PEI
580: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
581: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
582: AND PEO.PER_INFORMATION1 = '13'

Line 1014: PER_JOBS JOB

1010: PER_PEOPLE_EXTRA_INFO PPET,
1011: HR_LOOKUPS HL,
1012: PER_PAY_PROPOSALS PPP,
1013: PER_PAY_BASES PPB,
1014: PER_JOBS JOB
1015: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1016: AND PAF.PERSON_ID = PEO.PERSON_ID
1017: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1018: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'

Line 1187: PER_JOBS JOB,

1183: PER_PEOPLE_EXTRA_INFO PPET,
1184: HR_LOOKUPS HL,
1185: PER_PAY_PROPOSALS PPP,
1186: PER_PAY_BASES PPB,
1187: PER_JOBS JOB,
1188: PER_PEOPLE_EXTRA_INFO PEI
1189: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1190: AND PAF.PERSON_ID = PEO.PERSON_ID
1191: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1625: PER_JOBS JOB

1621: PER_PEOPLE_EXTRA_INFO PPET,
1622: HR_LOOKUPS HL,
1623: PER_PAY_PROPOSALS PPP,
1624: PER_PAY_BASES PPB,
1625: PER_JOBS JOB
1626: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1627: AND PAF.PERSON_ID = PPET.PERSON_ID
1628: AND PAF.PERSON_ID = PEO.PERSON_ID
1629: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1798: PER_JOBS JOB,

1794: PER_PEOPLE_EXTRA_INFO PPET,
1795: HR_LOOKUPS HL,
1796: PER_PAY_PROPOSALS PPP,
1797: PER_PAY_BASES PPB,
1798: PER_JOBS JOB,
1799: PER_PEOPLE_EXTRA_INFO PEI
1800: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1801: AND PAF.PERSON_ID = PPET.PERSON_ID
1802: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 2233: PER_JOBS JOB

2229: PER_PEOPLE_EXTRA_INFO PPET,
2230: HR_LOOKUPS HL,
2231: PER_PAY_PROPOSALS PPP,
2232: PER_PAY_BASES PPB,
2233: PER_JOBS JOB
2234: WHERE PAF.PERSON_ID = PPET.PERSON_ID
2235: AND PAF.PERSON_ID = PEO.PERSON_ID
2236: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2237: AND PPET.INFORMATION_TYPE = 'PQH_TENURE_STATUS'

Line 2407: PER_JOBS JOB,

2403: PER_PEOPLE_EXTRA_INFO PPET,
2404: HR_LOOKUPS HL,
2405: PER_PAY_PROPOSALS PPP,
2406: PER_PAY_BASES PPB,
2407: PER_JOBS JOB,
2408: PER_PEOPLE_EXTRA_INFO PEI
2409: WHERE PAF.PERSON_ID = PPET.PERSON_ID
2410: AND PAF.PERSON_ID = PEO.PERSON_ID
2411: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 2844: PER_JOBS JOB

2840: PER_PEOPLE_EXTRA_INFO PPEA,
2841: HR_LOOKUPS HL,
2842: PER_PAY_PROPOSALS PPP,
2843: PER_PAY_BASES PPB,
2844: PER_JOBS JOB
2845: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2846: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2847: AND PAF.PERSON_ID = PPEA.PERSON_ID
2848: AND PPEA.INFORMATION_TYPE = 'PQH_ACADEMIC_RANK'

Line 3021: PER_JOBS JOB,

3017: PER_PEOPLE_EXTRA_INFO PPEA,
3018: HR_LOOKUPS HL,
3019: PER_PAY_PROPOSALS PPP,
3020: PER_PAY_BASES PPB,
3021: PER_JOBS JOB,
3022: PER_PEOPLE_EXTRA_INFO PEI
3023: WHERE PAF.PERSON_ID = PEO.PERSON_ID
3024: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
3025: AND PEO.PER_INFORMATION1 = '13'

Line 3459: PER_JOBS JOB

3455: PER_ASSIGNMENT_STATUS_TYPES AST,
3456: HR_LOOKUPS HL,
3457: PER_PAY_PROPOSALS PPP,
3458: PER_PAY_BASES PPB,
3459: PER_JOBS JOB
3460: WHERE PAF.PERSON_ID = PEO.PERSON_ID
3461: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
3462: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE
3463: AND PAF.EFFECTIVE_END_DATE

Line 3635: PER_JOBS JOB,

3631: PER_ASSIGNMENT_STATUS_TYPES AST,
3632: HR_LOOKUPS HL,
3633: PER_PAY_PROPOSALS PPP,
3634: PER_PAY_BASES PPB,
3635: PER_JOBS JOB,
3636: PER_PEOPLE_EXTRA_INFO PEI
3637: WHERE PAF.PERSON_ID = PEO.PERSON_ID
3638: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
3639: AND PEO.PER_INFORMATION1 = '13'