APPS.PQH_PQIPED8_XMLP_PKG dependencies on PER_PAY_BASES

Line 404: PER_PAY_BASES PPB,

400: PER_PEOPLE_EXTRA_INFO PPEA,
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

Line 577: PER_PAY_BASES PPB,

573: PER_PEOPLE_EXTRA_INFO PPEA,
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'

Line 1013: PER_PAY_BASES PPB,

1009: PER_ASSIGNMENT_STATUS_TYPES AST,
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'

Line 1186: PER_PAY_BASES PPB,

1182: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 1624: PER_PAY_BASES PPB,

1620: PER_PEOPLE_EXTRA_INFO PPEA,
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

Line 1797: PER_PAY_BASES PPB,

1793: PER_PEOPLE_EXTRA_INFO PPEA,
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

Line 2232: PER_PAY_BASES PPB,

2228: PER_ASSIGNMENT_STATUS_TYPES AST,
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'

Line 2406: PER_PAY_BASES PPB,

2402: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 2843: PER_PAY_BASES PPB,

2839: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 3020: PER_PAY_BASES PPB,

3016: PER_ASSIGNMENT_STATUS_TYPES AST,
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'

Line 3458: PER_PAY_BASES PPB,

3454: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 3634: PER_PAY_BASES PPB,

3630: PER_ALL_ASSIGNMENTS_F PAF,
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'