DBA Data[Home] [Help]

APPS.PQH_PQIPED9_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 406: PER_ASSIGNMENT_STATUS_TYPES AST,

402: --
403: FROM
404: PER_ALL_PEOPLE_F PEO,
405: PER_ALL_ASSIGNMENTS_F PAF,
406: PER_ASSIGNMENT_STATUS_TYPES AST,
407: PER_PEOPLE_EXTRA_INFO PPET,
408: PER_JOBS JOB,
409: HR_LOOKUPS HL
410: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 551: PER_ASSIGNMENT_STATUS_TYPES AST,

547: ,NULL)) URWMEN
548: FROM
549: PER_ALL_PEOPLE_F PEO,
550: PER_ALL_ASSIGNMENTS_F PAF,
551: PER_ASSIGNMENT_STATUS_TYPES AST,
552: PER_PEOPLE_EXTRA_INFO PPET,
553: PER_JOBS JOB,
554: HR_LOOKUPS HL,
555: PER_PEOPLE_EXTRA_INFO PEI

Line 959: PER_ASSIGNMENT_STATUS_TYPES AST,

955: --
956: FROM
957: PER_ALL_PEOPLE_F PEO,
958: PER_ALL_ASSIGNMENTS_F PAF,
959: PER_ASSIGNMENT_STATUS_TYPES AST,
960: PER_PEOPLE_EXTRA_INFO PPET,
961: PER_JOBS JOB,
962: HR_LOOKUPS HL
963: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 1104: PER_ASSIGNMENT_STATUS_TYPES AST,

1100: ,NULL)) URWMEN
1101: FROM
1102: PER_ALL_PEOPLE_F PEO,
1103: PER_ALL_ASSIGNMENTS_F PAF,
1104: PER_ASSIGNMENT_STATUS_TYPES AST,
1105: PER_PEOPLE_EXTRA_INFO PPET,
1106: PER_JOBS JOB,
1107: HR_LOOKUPS HL,
1108: PER_PEOPLE_EXTRA_INFO PEI

Line 1512: PER_ASSIGNMENT_STATUS_TYPES AST,

1508: --
1509: FROM
1510: PER_ALL_PEOPLE_F PEO,
1511: PER_ALL_ASSIGNMENTS_F PAF,
1512: PER_ASSIGNMENT_STATUS_TYPES AST,
1513: PER_JOBS JOB,
1514: HR_LOOKUPS HL
1515: WHERE PAF.PERSON_ID = PEO.PERSON_ID
1516: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1660: PER_ASSIGNMENT_STATUS_TYPES AST,

1656: ,NULL)) URWMEN
1657: FROM
1658: PER_ALL_PEOPLE_F PEO,
1659: PER_ALL_ASSIGNMENTS_F PAF,
1660: PER_ASSIGNMENT_STATUS_TYPES AST,
1661: PER_JOBS JOB,
1662: HR_LOOKUPS HL,
1663: PER_PEOPLE_EXTRA_INFO PEI
1664: WHERE PAF.PERSON_ID = PEO.PERSON_ID

Line 2079: PER_ASSIGNMENT_STATUS_TYPES AST,

2075: --
2076: FROM
2077: PER_ALL_PEOPLE_F PEO,
2078: PER_ALL_ASSIGNMENTS_F PAF,
2079: PER_ASSIGNMENT_STATUS_TYPES AST,
2080: PER_JOBS JOB,
2081: HR_LOOKUPS HL
2082: WHERE PEO.PERSON_ID = PAF.PERSON_ID
2083: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 2218: PER_ASSIGNMENT_STATUS_TYPES AST,

2214: ,NULL)) URWMEN
2215: FROM
2216: PER_ALL_PEOPLE_F PEO,
2217: PER_ALL_ASSIGNMENTS_F PAF,
2218: PER_ASSIGNMENT_STATUS_TYPES AST,
2219: PER_JOBS JOB,
2220: HR_LOOKUPS HL,
2221: PER_PEOPLE_EXTRA_INFO PEI
2222: WHERE PEO.PERSON_ID = PAF.PERSON_ID