DBA Data[Home] [Help]

APPS.PQH_PQIPED9_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 213: PER_ASSIGNMENT_STATUS_TYPES AST,

209: ,NULL)))) URWMEN
210: FROM
211: PER_ALL_PEOPLE_F PEO,
212: PER_ALL_ASSIGNMENTS_F PAF,
213: PER_ASSIGNMENT_STATUS_TYPES AST,
214: PER_PEOPLE_EXTRA_INFO PPET,
215: PER_JOBS JOB,
216: HR_LOOKUPS HL
217: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 357: PER_ASSIGNMENT_STATUS_TYPES AST,

353: ,NULL)) URWMEN
354: FROM
355: PER_ALL_PEOPLE_F PEO,
356: PER_ALL_ASSIGNMENTS_F PAF,
357: PER_ASSIGNMENT_STATUS_TYPES AST,
358: PER_PEOPLE_EXTRA_INFO PPET,
359: PER_JOBS JOB,
360: HR_LOOKUPS HL,
361: PER_PEOPLE_EXTRA_INFO PEI

Line 576: PER_ASSIGNMENT_STATUS_TYPES AST,

572: ,NULL)))) URWMEN
573: FROM
574: PER_ALL_PEOPLE_F PEO,
575: PER_ALL_ASSIGNMENTS_F PAF,
576: PER_ASSIGNMENT_STATUS_TYPES AST,
577: PER_PEOPLE_EXTRA_INFO PPET,
578: PER_JOBS JOB,
579: HR_LOOKUPS HL
580: WHERE PAF.PERSON_ID = PPET.PERSON_ID

Line 720: PER_ASSIGNMENT_STATUS_TYPES AST,

716: ,NULL)) URWMEN
717: FROM
718: PER_ALL_PEOPLE_F PEO,
719: PER_ALL_ASSIGNMENTS_F PAF,
720: PER_ASSIGNMENT_STATUS_TYPES AST,
721: PER_PEOPLE_EXTRA_INFO PPET,
722: PER_JOBS JOB,
723: HR_LOOKUPS HL,
724: PER_PEOPLE_EXTRA_INFO PEI

Line 939: PER_ASSIGNMENT_STATUS_TYPES AST,

935: ,NULL)))) URWMEN
936: FROM
937: PER_ALL_PEOPLE_F PEO,
938: PER_ALL_ASSIGNMENTS_F PAF,
939: PER_ASSIGNMENT_STATUS_TYPES AST,
940: PER_JOBS JOB,
941: HR_LOOKUPS HL
942: WHERE PAF.PERSON_ID = PEO.PERSON_ID
943: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1086: PER_ASSIGNMENT_STATUS_TYPES AST,

1082: ,NULL)) URWMEN
1083: FROM
1084: PER_ALL_PEOPLE_F PEO,
1085: PER_ALL_ASSIGNMENTS_F PAF,
1086: PER_ASSIGNMENT_STATUS_TYPES AST,
1087: PER_JOBS JOB,
1088: HR_LOOKUPS HL,
1089: PER_PEOPLE_EXTRA_INFO PEI
1090: WHERE PAF.PERSON_ID = PEO.PERSON_ID

Line 1316: PER_ASSIGNMENT_STATUS_TYPES AST,

1312: ,NULL)) TOTWMEN
1313: FROM
1314: PER_ALL_PEOPLE_F PEO,
1315: PER_ALL_ASSIGNMENTS_F PAF,
1316: PER_ASSIGNMENT_STATUS_TYPES AST,
1317: PER_JOBS JOB,
1318: HR_LOOKUPS HL
1319: WHERE PEO.PERSON_ID = PAF.PERSON_ID
1320: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 1454: PER_ASSIGNMENT_STATUS_TYPES AST,

1450: ,NULL)) URWMEN
1451: FROM
1452: PER_ALL_PEOPLE_F PEO,
1453: PER_ALL_ASSIGNMENTS_F PAF,
1454: PER_ASSIGNMENT_STATUS_TYPES AST,
1455: PER_JOBS JOB,
1456: HR_LOOKUPS HL,
1457: PER_PEOPLE_EXTRA_INFO PEI
1458: WHERE PEO.PERSON_ID = PAF.PERSON_ID