DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 539: PER_PEOPLE_EXTRA_INFO PEI

535: HR_LOOKUPS HL,
536: PER_JOBS JOB,
537: PER_SHARED_TYPES PST,
538: PER_SHARED_TYPES PST1,
539: PER_PEOPLE_EXTRA_INFO PEI
540: WHERE PEO.PERSON_ID = ASS.PERSON_ID
541: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
542: AND PEO.PER_INFORMATION1 = '13'
543: AND PEO.PERSON_ID = pei.person_id (+)

Line 550: PER_PEOPLE_EXTRA_INFO PEI2

546: AND not exists (
547: SELECT
548: 1
549: FROM
550: PER_PEOPLE_EXTRA_INFO PEI2
551: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
552: AND PEI2.PERSON_ID = PEI.PERSON_ID )
553: AND PEI.PERSON_EXTRA_INFO_ID = (
554: SELECT

Line 557: PER_PEOPLE_EXTRA_INFO PEI1

553: AND PEI.PERSON_EXTRA_INFO_ID = (
554: SELECT
555: MAX(PEI1.PERSON_EXTRA_INFO_ID)
556: FROM
557: PER_PEOPLE_EXTRA_INFO PEI1
558: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
559: OR ( not exists (
560: SELECT
561: PERSON_EXTRA_INFO_ID

Line 563: PER_PEOPLE_EXTRA_INFO PEI3

559: OR ( not exists (
560: SELECT
561: PERSON_EXTRA_INFO_ID
562: FROM
563: PER_PEOPLE_EXTRA_INFO PEI3
564: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
565: AND PCO.PERSON_ID = PEO.PERSON_ID
566: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
567: ,CP_FR

Line 969: PER_PEOPLE_EXTRA_INFO PEI

965: HR_LOOKUPS HL,
966: PER_JOBS JOB,
967: PER_SHARED_TYPES PST,
968: PER_SHARED_TYPES PST1,
969: PER_PEOPLE_EXTRA_INFO PEI
970: WHERE PEO.PERSON_ID = ASS.PERSON_ID
971: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
972: AND PEO.PER_INFORMATION1 = '13'
973: AND PEO.PERSON_ID = pei.person_id (+)

Line 980: PER_PEOPLE_EXTRA_INFO PEI2

976: AND not exists (
977: SELECT
978: 1
979: FROM
980: PER_PEOPLE_EXTRA_INFO PEI2
981: WHERE PEI2.INFORMATION_TYPE = 'PER_US_ADDL_ETHNIC_CAT'
982: AND PEI2.PERSON_ID = PEI.PERSON_ID )
983: AND PEI.PERSON_EXTRA_INFO_ID = (
984: SELECT

Line 987: PER_PEOPLE_EXTRA_INFO PEI1

983: AND PEI.PERSON_EXTRA_INFO_ID = (
984: SELECT
985: MAX(PEI1.PERSON_EXTRA_INFO_ID)
986: FROM
987: PER_PEOPLE_EXTRA_INFO PEI1
988: WHERE PEI1.PERSON_ID = PEI.PERSON_ID ) )
989: OR ( not exists (
990: SELECT
991: PERSON_EXTRA_INFO_ID

Line 993: PER_PEOPLE_EXTRA_INFO PEI3

989: OR ( not exists (
990: SELECT
991: PERSON_EXTRA_INFO_ID
992: FROM
993: PER_PEOPLE_EXTRA_INFO PEI3
994: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
995: AND PCO.PERSON_ID = PEO.PERSON_ID
996: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY
997: ,CP_FR