APPS.IRC_UTILITIES_PKG dependencies on HR_LOOKUPS

Line 1565: FROM HR_LOOKUPS HRL,

1561: irc_utilities_pkg.getVacancyRunFunctionUrl('|| l_funcId||',
1562: pav.vacancy_id,
1563: pav.primary_posting_id,
1564: 1) rlink
1565: FROM HR_LOOKUPS HRL,
1566: HR_LOOKUPS HL2,
1567: PER_ALL_VACANCIES PAV,
1568: PER_RECRUITMENT_ACTIVITIES PRA,
1569: PER_RECRUITMENT_ACTIVITY_FOR PRF,

Line 1566: HR_LOOKUPS HL2,

1562: pav.vacancy_id,
1563: pav.primary_posting_id,
1564: 1) rlink
1565: FROM HR_LOOKUPS HRL,
1566: HR_LOOKUPS HL2,
1567: PER_ALL_VACANCIES PAV,
1568: PER_RECRUITMENT_ACTIVITIES PRA,
1569: PER_RECRUITMENT_ACTIVITY_FOR PRF,
1570: IRC_POSTING_CONTENTS_VL IPC,

Line 1573: HR_LOOKUPS HLW,

1569: PER_RECRUITMENT_ACTIVITY_FOR PRF,
1570: IRC_POSTING_CONTENTS_VL IPC,
1571: IRC_SEARCH_CRITERIA IVS,
1572: HR_LOCATIONS_ALL LOC,
1573: HR_LOOKUPS HLW,
1574: HR_LOOKUPS HLT,
1575: IRC_ALL_RECRUITING_SITES ias WHERE pav.status = ''APPROVED''
1576: AND PAV.VACANCY_ID = PRF.VACANCY_ID
1577: AND PRF.RECRUITMENT_ACTIVITY_ID = PRA.RECRUITMENT_ACTIVITY_ID

Line 1574: HR_LOOKUPS HLT,

1570: IRC_POSTING_CONTENTS_VL IPC,
1571: IRC_SEARCH_CRITERIA IVS,
1572: HR_LOCATIONS_ALL LOC,
1573: HR_LOOKUPS HLW,
1574: HR_LOOKUPS HLT,
1575: IRC_ALL_RECRUITING_SITES ias WHERE pav.status = ''APPROVED''
1576: AND PAV.VACANCY_ID = PRF.VACANCY_ID
1577: AND PRF.RECRUITMENT_ACTIVITY_ID = PRA.RECRUITMENT_ACTIVITY_ID
1578: AND PRA.POSTING_CONTENT_ID = IPC.POSTING_CONTENT_ID

Line 2255: ,hr_lookups hl

2251: hl.Meaning
2252: FROM per_person_types typ
2253: ,per_person_type_usages_f ptu
2254: ,per_all_people_f ppf
2255: ,hr_lookups hl
2256: WHERE ppf.party_id = p_party_id
2257: AND p_eff_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
2258: AND ppf.person_id = ptu.person_id
2259: AND typ.system_person_type = 'EX_EMP'

Line 2297: from hr_lookups

2293: end if;
2294: --
2295: if csr_person_types%notfound then
2296: select meaning into l_rehire_recommendation
2297: from hr_lookups
2298: where lookup_type = 'IRC_REHIRE_RECOMMENDATION'
2299: and lookup_code = 'NOT_APPLICABLE';
2300: end if;
2301: close csr_person_types;

Line 2357: from hr_lookups

2353: end if;
2354: --
2355: if csr_person_types%notfound then
2356: select lookup_code into l_rehire_recommendation
2357: from hr_lookups
2358: where lookup_type = 'IRC_REHIRE_RECOMMENDATION'
2359: and lookup_code = 'NOT_APPLICABLE';
2360: end if;
2361: --

Line 2374: FROM per_phones phn, hr_lookups hlk

2370: begin
2371:
2372: SELECT phn.phone_number || nvl2(hlk.meaning, '(' || hlk.meaning || ')', null)
2373: into l_number
2374: FROM per_phones phn, hr_lookups hlk
2375: WHERE phn.parent_id = pPersonIdIn
2376: AND phn.parent_table = 'PER_ALL_PEOPLE_F'
2377: AND trunc(SYSDATE) BETWEEN phn.date_from (+)
2378: AND nvl (phn.date_to , trunc(SYSDATE))