APPS.PQH_PQIPED7_XMLP_PKG dependencies on HR_LOOKUPS

Line 145: HR_LOOKUPS HL

141: PER_ASSIGNMENT_STATUS_TYPES AST,
142: PER_JOBS JOB,
143: PER_PAY_PROPOSALS PPP,
144: PER_PAY_BASES PPB,
145: HR_LOOKUPS HL
146: WHERE PEO.PERSON_ID = ASS.PERSON_ID
147: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
148: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
149: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

Line 195: HR_LOOKUPS HL,

191: PER_ASSIGNMENT_STATUS_TYPES AST,
192: PER_JOBS JOB,
193: PER_PAY_PROPOSALS PPP,
194: PER_PAY_BASES PPB,
195: HR_LOOKUPS HL,
196: PER_PEOPLE_EXTRA_INFO PEI
197: WHERE PEO.PERSON_ID = ASS.PERSON_ID
198: AND PEO.PER_INFORMATION1 = '13'
199: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 267: HR_LOOKUPS HL

263: PER_ASSIGNMENT_STATUS_TYPES AST,
264: PER_JOBS JOB,
265: PER_PAY_PROPOSALS PPP,
266: PER_PAY_BASES PPB,
267: HR_LOOKUPS HL
268: WHERE PEO.PERSON_ID = ASS.PERSON_ID
269: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
270: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
271: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

Line 317: HR_LOOKUPS HL,

313: PER_ASSIGNMENT_STATUS_TYPES AST,
314: PER_JOBS JOB,
315: PER_PAY_PROPOSALS PPP,
316: PER_PAY_BASES PPB,
317: HR_LOOKUPS HL,
318: PER_PEOPLE_EXTRA_INFO PEI
319: WHERE PEO.PERSON_ID = ASS.PERSON_ID
320: AND PEO.PER_INFORMATION1 = '13'
321: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'