DBA Data[Home] [Help]

APPS.PQH_PQIPED8_XMLP_PKG dependencies on HR_LOOKUPS

Line 201: HR_LOOKUPS HLA,

197: ,1
198: ,NULL)
199: ,NULL)))) URWMEN
200: FROM
201: HR_LOOKUPS HLA,
202: PER_ALL_PEOPLE_F PEO,
203: PER_ALL_ASSIGNMENTS_F PAF,
204: PER_ASSIGNMENT_STATUS_TYPES AST,
205: PER_PEOPLE_EXTRA_INFO PPEA,

Line 207: HR_LOOKUPS HL,

203: PER_ALL_ASSIGNMENTS_F PAF,
204: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 373: HR_LOOKUPS HLA,

369: ,1
370: ,NULL)
371: ,NULL)) URWMEN
372: FROM
373: HR_LOOKUPS HLA,
374: PER_ALL_PEOPLE_F PEO,
375: PER_ALL_ASSIGNMENTS_F PAF,
376: PER_ASSIGNMENT_STATUS_TYPES AST,
377: PER_PEOPLE_EXTRA_INFO PPEA,

Line 379: HR_LOOKUPS HL,

375: PER_ALL_ASSIGNMENTS_F PAF,
376: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 625: HR_LOOKUPS HL,

621: PER_ALL_PEOPLE_F PEO,
622: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 797: HR_LOOKUPS HL,

793: PER_ALL_PEOPLE_F PEO,
794: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 1040: HR_LOOKUPS HLA,

1036: ,1
1037: ,NULL)
1038: ,NULL)))) URWMEN
1039: FROM
1040: HR_LOOKUPS HLA,
1041: PER_ALL_PEOPLE_F PEO,
1042: PER_ALL_ASSIGNMENTS_F PAF,
1043: PER_ASSIGNMENT_STATUS_TYPES AST,
1044: PER_PEOPLE_EXTRA_INFO PPEA,

Line 1046: HR_LOOKUPS HL,

1042: PER_ALL_ASSIGNMENTS_F PAF,
1043: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 1212: HR_LOOKUPS HLA,

1208: ,1
1209: ,NULL)
1210: ,NULL)) URWMEN
1211: FROM
1212: HR_LOOKUPS HLA,
1213: PER_ALL_PEOPLE_F PEO,
1214: PER_ALL_ASSIGNMENTS_F PAF,
1215: PER_ASSIGNMENT_STATUS_TYPES AST,
1216: PER_PEOPLE_EXTRA_INFO PPEA,

Line 1218: HR_LOOKUPS HL,

1214: PER_ALL_ASSIGNMENTS_F PAF,
1215: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 1464: HR_LOOKUPS HL,

1460: PER_ALL_PEOPLE_F PEO,
1461: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 1636: HR_LOOKUPS HL,

1632: PER_ALL_PEOPLE_F PEO,
1633: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 1879: HR_LOOKUPS HLA,

1875: ,1
1876: ,NULL)
1877: ,NULL)))) URWMEN
1878: FROM
1879: HR_LOOKUPS HLA,
1880: PER_ALL_PEOPLE_F PEO,
1881: PER_ALL_ASSIGNMENTS_F PAF,
1882: PER_ASSIGNMENT_STATUS_TYPES AST,
1883: PER_PEOPLE_EXTRA_INFO PPEA,

Line 1884: HR_LOOKUPS HL,

1880: PER_ALL_PEOPLE_F PEO,
1881: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 2054: HR_LOOKUPS HLA,

2050: ,1
2051: ,NULL)
2052: ,NULL)) URWMEN
2053: FROM
2054: HR_LOOKUPS HLA,
2055: PER_ALL_PEOPLE_F PEO,
2056: PER_ALL_ASSIGNMENTS_F PAF,
2057: PER_ASSIGNMENT_STATUS_TYPES AST,
2058: PER_PEOPLE_EXTRA_INFO PPEA,

Line 2059: HR_LOOKUPS HL,

2055: PER_ALL_PEOPLE_F PEO,
2056: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 2308: HR_LOOKUPS HL,

2304: FROM
2305: PER_ALL_PEOPLE_F PEO,
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

Line 2483: HR_LOOKUPS HL,

2479: FROM
2480: PER_ALL_PEOPLE_F PEO,
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