DBA Data[Home] [Help]

APPS.PQH_PQIPED8_XMLP_PKG dependencies on HR_LOOKUPS

Line 396: HR_LOOKUPS HLA,

392: ,NULL)))) TMRWMEN -- Added New column for IPED Enh #7033011
393: Commented for bug#11736960 ends */
394: --
395: FROM
396: HR_LOOKUPS HLA,
397: PER_ALL_PEOPLE_F PEO,
398: PER_ALL_ASSIGNMENTS_F PAF,
399: PER_ASSIGNMENT_STATUS_TYPES AST,
400: PER_PEOPLE_EXTRA_INFO PPEA,

Line 402: HR_LOOKUPS HL,

398: PER_ALL_ASSIGNMENTS_F PAF,
399: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 569: HR_LOOKUPS HLA,

565: ,1
566: ,NULL)
567: ,NULL)) URWMEN
568: FROM
569: HR_LOOKUPS HLA,
570: PER_ALL_PEOPLE_F PEO,
571: PER_ALL_ASSIGNMENTS_F PAF,
572: PER_ASSIGNMENT_STATUS_TYPES AST,
573: PER_PEOPLE_EXTRA_INFO PPEA,

Line 575: HR_LOOKUPS HL,

571: PER_ALL_ASSIGNMENTS_F PAF,
572: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 1011: HR_LOOKUPS HL,

1007: PER_ALL_PEOPLE_F PEO,
1008: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 1184: HR_LOOKUPS HL,

1180: PER_ALL_PEOPLE_F PEO,
1181: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 1616: HR_LOOKUPS HLA,

1612: ,NULL)))) TMRWMEN -- Added New column for IPED Enh #7033011
1613: Commented for bug#11736960 ends */
1614: --
1615: FROM
1616: HR_LOOKUPS HLA,
1617: PER_ALL_PEOPLE_F PEO,
1618: PER_ALL_ASSIGNMENTS_F PAF,
1619: PER_ASSIGNMENT_STATUS_TYPES AST,
1620: PER_PEOPLE_EXTRA_INFO PPEA,

Line 1622: HR_LOOKUPS HL,

1618: PER_ALL_ASSIGNMENTS_F PAF,
1619: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 1789: HR_LOOKUPS HLA,

1785: ,1
1786: ,NULL)
1787: ,NULL)) URWMEN
1788: FROM
1789: HR_LOOKUPS HLA,
1790: PER_ALL_PEOPLE_F PEO,
1791: PER_ALL_ASSIGNMENTS_F PAF,
1792: PER_ASSIGNMENT_STATUS_TYPES AST,
1793: PER_PEOPLE_EXTRA_INFO PPEA,

Line 1795: HR_LOOKUPS HL,

1791: PER_ALL_ASSIGNMENTS_F PAF,
1792: PER_ASSIGNMENT_STATUS_TYPES AST,
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

Line 2230: HR_LOOKUPS HL,

2226: PER_ALL_PEOPLE_F PEO,
2227: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 2404: HR_LOOKUPS HL,

2400: PER_ALL_PEOPLE_F PEO,
2401: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 2836: HR_LOOKUPS HLA,

2832: ,NULL)))) TMRWMEN -- Added New column for IPED Enh #7033011
2833: Commented for bug#11736960 ends */
2834: --
2835: FROM
2836: HR_LOOKUPS HLA,
2837: PER_ALL_PEOPLE_F PEO,
2838: PER_ALL_ASSIGNMENTS_F PAF,
2839: PER_ASSIGNMENT_STATUS_TYPES AST,
2840: PER_PEOPLE_EXTRA_INFO PPEA,

Line 2841: HR_LOOKUPS HL,

2837: PER_ALL_PEOPLE_F PEO,
2838: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 3013: HR_LOOKUPS HLA,

3009: ,1
3010: ,NULL)
3011: ,NULL)) URWMEN
3012: FROM
3013: HR_LOOKUPS HLA,
3014: PER_ALL_PEOPLE_F PEO,
3015: PER_ALL_ASSIGNMENTS_F PAF,
3016: PER_ASSIGNMENT_STATUS_TYPES AST,
3017: PER_PEOPLE_EXTRA_INFO PPEA,

Line 3018: HR_LOOKUPS HL,

3014: PER_ALL_PEOPLE_F PEO,
3015: PER_ALL_ASSIGNMENTS_F PAF,
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

Line 3456: HR_LOOKUPS HL,

3452: FROM
3453: PER_ALL_PEOPLE_F PEO,
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

Line 3632: HR_LOOKUPS HL,

3628: FROM
3629: PER_ALL_PEOPLE_F PEO,
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