DBA Data[Home] [Help]

APPS.PQH_PQIPED10_XMLP_PKG dependencies on HR_LOOKUPS

Line 288: HR_LOOKUPS HL

284: PER_ASSIGNMENT_STATUS_TYPES AST,
285: PER_JOBS JOB,
286: PER_PAY_PROPOSALS PPP,
287: PER_PAY_BASES PPB,
288: HR_LOOKUPS HL
289: WHERE PEO.PERSON_ID = ASS.PERSON_ID
290: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
291: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
292: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

Line 442: HR_LOOKUPS HL,

438: PER_ASSIGNMENT_STATUS_TYPES AST,
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'

Line 673: HR_LOOKUPS HL

669: PER_ASSIGNMENT_STATUS_TYPES AST,
670: PER_JOBS JOB,
671: PER_PAY_PROPOSALS PPP,
672: PER_PAY_BASES PPB,
673: HR_LOOKUPS HL
674: WHERE PEO.PERSON_ID = ASS.PERSON_ID
675: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
676: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
677: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY

Line 825: HR_LOOKUPS HL,

821: PER_ASSIGNMENT_STATUS_TYPES AST,
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'