APPS.PQH_PQIPED8_XMLP_PKG dependencies on PER_PAY_BASES

Line 209: PER_PAY_BASES PPB,

205: PER_PEOPLE_EXTRA_INFO PPEA,
206: PER_PEOPLE_EXTRA_INFO PPET,
207: HR_LOOKUPS HL,
208: PER_PAY_PROPOSALS PPP,
209: PER_PAY_BASES PPB,
210: PER_JOBS JOB
211: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
212: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
213: AND PAF.PERSON_ID = PPET.PERSON_ID

Line 381: PER_PAY_BASES PPB,

377: PER_PEOPLE_EXTRA_INFO PPEA,
378: PER_PEOPLE_EXTRA_INFO PPET,
379: HR_LOOKUPS HL,
380: PER_PAY_PROPOSALS PPP,
381: PER_PAY_BASES PPB,
382: PER_JOBS JOB,
383: PER_PEOPLE_EXTRA_INFO PEI
384: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
385: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 627: PER_PAY_BASES PPB,

623: PER_ASSIGNMENT_STATUS_TYPES AST,
624: PER_PEOPLE_EXTRA_INFO PPET,
625: HR_LOOKUPS HL,
626: PER_PAY_PROPOSALS PPP,
627: PER_PAY_BASES PPB,
628: PER_JOBS JOB
629: WHERE PAF.PERSON_ID = PPET.PERSON_ID
630: AND PAF.PERSON_ID = PEO.PERSON_ID
631: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 799: PER_PAY_BASES PPB,

795: PER_ASSIGNMENT_STATUS_TYPES AST,
796: PER_PEOPLE_EXTRA_INFO PPET,
797: HR_LOOKUPS HL,
798: PER_PAY_PROPOSALS PPP,
799: PER_PAY_BASES PPB,
800: PER_JOBS JOB,
801: PER_PEOPLE_EXTRA_INFO PEI
802: WHERE PAF.PERSON_ID = PPET.PERSON_ID
803: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1048: PER_PAY_BASES PPB,

1044: PER_PEOPLE_EXTRA_INFO PPEA,
1045: PER_PEOPLE_EXTRA_INFO PPET,
1046: HR_LOOKUPS HL,
1047: PER_PAY_PROPOSALS PPP,
1048: PER_PAY_BASES PPB,
1049: PER_JOBS JOB
1050: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1051: AND PAF.PERSON_ID = PPET.PERSON_ID
1052: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1220: PER_PAY_BASES PPB,

1216: PER_PEOPLE_EXTRA_INFO PPEA,
1217: PER_PEOPLE_EXTRA_INFO PPET,
1218: HR_LOOKUPS HL,
1219: PER_PAY_PROPOSALS PPP,
1220: PER_PAY_BASES PPB,
1221: PER_JOBS JOB,
1222: PER_PEOPLE_EXTRA_INFO PEI
1223: WHERE PAF.PERSON_ID = PPEA.PERSON_ID
1224: AND PAF.PERSON_ID = PPET.PERSON_ID

Line 1466: PER_PAY_BASES PPB,

1462: PER_ASSIGNMENT_STATUS_TYPES AST,
1463: PER_PEOPLE_EXTRA_INFO PPET,
1464: HR_LOOKUPS HL,
1465: PER_PAY_PROPOSALS PPP,
1466: PER_PAY_BASES PPB,
1467: PER_JOBS JOB
1468: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1469: AND PAF.PERSON_ID = PEO.PERSON_ID
1470: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1638: PER_PAY_BASES PPB,

1634: PER_ASSIGNMENT_STATUS_TYPES AST,
1635: PER_PEOPLE_EXTRA_INFO PPET,
1636: HR_LOOKUPS HL,
1637: PER_PAY_PROPOSALS PPP,
1638: PER_PAY_BASES PPB,
1639: PER_JOBS JOB,
1640: PER_PEOPLE_EXTRA_INFO PEI
1641: WHERE PAF.PERSON_ID = PPET.PERSON_ID
1642: AND PAF.PERSON_ID = PEO.PERSON_ID

Line 1886: PER_PAY_BASES PPB,

1882: PER_ASSIGNMENT_STATUS_TYPES AST,
1883: PER_PEOPLE_EXTRA_INFO PPEA,
1884: HR_LOOKUPS HL,
1885: PER_PAY_PROPOSALS PPP,
1886: PER_PAY_BASES PPB,
1887: PER_JOBS JOB
1888: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1889: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
1890: AND PAF.PERSON_ID = PPEA.PERSON_ID

Line 2061: PER_PAY_BASES PPB,

2057: PER_ASSIGNMENT_STATUS_TYPES AST,
2058: PER_PEOPLE_EXTRA_INFO PPEA,
2059: HR_LOOKUPS HL,
2060: PER_PAY_PROPOSALS PPP,
2061: PER_PAY_BASES PPB,
2062: PER_JOBS JOB,
2063: PER_PEOPLE_EXTRA_INFO PEI
2064: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2065: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 2310: PER_PAY_BASES PPB,

2306: PER_ALL_ASSIGNMENTS_F PAF,
2307: PER_ASSIGNMENT_STATUS_TYPES AST,
2308: HR_LOOKUPS HL,
2309: PER_PAY_PROPOSALS PPP,
2310: PER_PAY_BASES PPB,
2311: PER_JOBS JOB
2312: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2313: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
2314: AND P_REPORT_DATE BETWEEN PAF.EFFECTIVE_START_DATE

Line 2485: PER_PAY_BASES PPB,

2481: PER_ALL_ASSIGNMENTS_F PAF,
2482: PER_ASSIGNMENT_STATUS_TYPES AST,
2483: HR_LOOKUPS HL,
2484: PER_PAY_PROPOSALS PPP,
2485: PER_PAY_BASES PPB,
2486: PER_JOBS JOB,
2487: PER_PEOPLE_EXTRA_INFO PEI
2488: WHERE PAF.PERSON_ID = PEO.PERSON_ID
2489: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'