APPS.PQH_PQIPED10_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 443: PER_PEOPLE_EXTRA_INFO PEI

439: PER_JOBS JOB,
440: PER_PAY_PROPOSALS PPP,
441: PER_PAY_BASES PPB,
442: HR_LOOKUPS HL,
443: PER_PEOPLE_EXTRA_INFO PEI
444: WHERE PEO.PERSON_ID = ASS.PERSON_ID
445: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
446: AND PEO.PER_INFORMATION1 = '13'
447: AND PEO.PERSON_ID = pei.person_id (+)

Line 454: PER_PEOPLE_EXTRA_INFO PEI2

450: AND not exists (
451: SELECT
452: 1
453: FROM
454: PER_PEOPLE_EXTRA_INFO PEI2
455: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
456: AND PEI2.PERSON_ID = PEI.PERSON_ID )
457: AND PEI.PERSON_EXTRA_INFO_ID = (
458: SELECT

Line 461: PER_PEOPLE_EXTRA_INFO PEI1

457: AND PEI.PERSON_EXTRA_INFO_ID = (
458: SELECT
459: MAX(PEI1.PERSON_EXTRA_INFO_ID)
460: FROM
461: PER_PEOPLE_EXTRA_INFO PEI1
462: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
463: OR ( not exists (
464: SELECT
465: PERSON_EXTRA_INFO_ID

Line 467: PER_PEOPLE_EXTRA_INFO PEI3

463: OR ( not exists (
464: SELECT
465: PERSON_EXTRA_INFO_ID
466: FROM
467: PER_PEOPLE_EXTRA_INFO PEI3
468: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
469: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
470: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
471: ,CP_FR

Line 826: PER_PEOPLE_EXTRA_INFO PEI

822: PER_JOBS JOB,
823: PER_PAY_PROPOSALS PPP,
824: PER_PAY_BASES PPB,
825: HR_LOOKUPS HL,
826: PER_PEOPLE_EXTRA_INFO PEI
827: WHERE PEO.PERSON_ID = ASS.PERSON_ID
828: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
829: AND PEO.PER_INFORMATION1 = '13'
830: AND PEO.PERSON_ID = pei.person_id (+)

Line 837: PER_PEOPLE_EXTRA_INFO PEI2

833: AND not exists (
834: SELECT
835: 1
836: FROM
837: PER_PEOPLE_EXTRA_INFO PEI2
838: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
839: AND PEI2.PERSON_ID = PEI.PERSON_ID )
840: AND PEI.PERSON_EXTRA_INFO_ID = (
841: SELECT

Line 844: PER_PEOPLE_EXTRA_INFO PEI1

840: AND PEI.PERSON_EXTRA_INFO_ID = (
841: SELECT
842: MAX(PEI1.PERSON_EXTRA_INFO_ID)
843: FROM
844: PER_PEOPLE_EXTRA_INFO PEI1
845: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
846: OR ( not exists (
847: SELECT
848: PERSON_EXTRA_INFO_ID

Line 850: PER_PEOPLE_EXTRA_INFO PEI3

846: OR ( not exists (
847: SELECT
848: PERSON_EXTRA_INFO_ID
849: FROM
850: PER_PEOPLE_EXTRA_INFO PEI3
851: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
852: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
853: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
854: ,CP_FR