DBA Data[Home] [Help]

APPS.PQH_PQIPED5_XMLP_PKG dependencies on PER_SHARED_TYPES

Line 356: PER_SHARED_TYPES PST,

352: PER_PAY_PROPOSALS PPP,
353: PER_PAY_BASES PPB,
354: HR_LOOKUPS HL,
355: PER_JOBS JOB,
356: PER_SHARED_TYPES PST,
357: PER_SHARED_TYPES PST1
358: WHERE PEO.PERSON_ID = ASS.PERSON_ID
359: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
360: AND PCO.PERSON_ID = PEO.PERSON_ID

Line 357: PER_SHARED_TYPES PST1

353: PER_PAY_BASES PPB,
354: HR_LOOKUPS HL,
355: PER_JOBS JOB,
356: PER_SHARED_TYPES PST,
357: PER_SHARED_TYPES PST1
358: WHERE PEO.PERSON_ID = ASS.PERSON_ID
359: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
360: AND PCO.PERSON_ID = PEO.PERSON_ID
361: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

Line 537: PER_SHARED_TYPES PST,

533: PER_PAY_PROPOSALS PPP,
534: PER_PAY_BASES PPB,
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'

Line 538: PER_SHARED_TYPES PST1,

534: PER_PAY_BASES PPB,
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'

Line 795: PER_SHARED_TYPES PST,

791: PER_PAY_PROPOSALS PPP,
792: PER_PAY_BASES PPB,
793: HR_LOOKUPS HL,
794: PER_JOBS JOB,
795: PER_SHARED_TYPES PST,
796: PER_SHARED_TYPES PST1
797: WHERE PEO.PERSON_ID = ASS.PERSON_ID
798: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
799: AND PCO.PERSON_ID = PEO.PERSON_ID

Line 796: PER_SHARED_TYPES PST1

792: PER_PAY_BASES PPB,
793: HR_LOOKUPS HL,
794: PER_JOBS JOB,
795: PER_SHARED_TYPES PST,
796: PER_SHARED_TYPES PST1
797: WHERE PEO.PERSON_ID = ASS.PERSON_ID
798: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
799: AND PCO.PERSON_ID = PEO.PERSON_ID
800: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

Line 967: PER_SHARED_TYPES PST,

963: PER_PAY_PROPOSALS PPP,
964: PER_PAY_BASES PPB,
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'

Line 968: PER_SHARED_TYPES PST1,

964: PER_PAY_BASES PPB,
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'