DBA Data[Home] [Help]

APPS.PQH_PQIPED7_XMLP_PKG dependencies on HR_LOOKUPS

Line 200: HR_LOOKUPS HL

196: PER_ASSIGNMENT_STATUS_TYPES AST,
197: PER_JOBS JOB,
198: PER_PAY_PROPOSALS PPP,
199: PER_PAY_BASES PPB,
200: HR_LOOKUPS HL
201: WHERE PEO.PERSON_ID = ASS.PERSON_ID
202: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
203: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
204: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

Line 252: HR_LOOKUPS HL,

248: PER_ASSIGNMENT_STATUS_TYPES AST,
249: PER_JOBS JOB,
250: PER_PAY_PROPOSALS PPP,
251: PER_PAY_BASES PPB,
252: HR_LOOKUPS HL,
253: PER_PEOPLE_EXTRA_INFO PEI
254: WHERE PEO.PERSON_ID = ASS.PERSON_ID
255: AND PEO.PER_INFORMATION1 = '13'
256: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 352: HR_LOOKUPS HL

348: PER_ASSIGNMENT_STATUS_TYPES AST,
349: PER_JOBS JOB,
350: PER_PAY_PROPOSALS PPP,
351: PER_PAY_BASES PPB,
352: HR_LOOKUPS HL
353: WHERE PEO.PERSON_ID = ASS.PERSON_ID
354: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
355: AND HL.LOOKUP_CODE = JOB.JOB_INFORMATION8
356: AND PQH_EMPLOYMENT_CATEGORY.IDENTIFY_EMPL_CATEGORY(ASS.EMPLOYMENT_CATEGORY, CP_FR, CP_FT, CP_PR, CP_PT) IN('PR')

Line 406: HR_LOOKUPS HL,

402: PER_ASSIGNMENT_STATUS_TYPES AST,
403: PER_JOBS JOB,
404: PER_PAY_PROPOSALS PPP,
405: PER_PAY_BASES PPB,
406: HR_LOOKUPS HL,
407: PER_PEOPLE_EXTRA_INFO PEI
408: WHERE PEO.PERSON_ID = ASS.PERSON_ID
409: AND PEO.PER_INFORMATION1 = '13'
410: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'