APPS.OTA_CRE_BUS dependencies on HR_LOOKUPS

Line 444: IF hr_api.not_exists_in_hr_lookups

440: ,p_argument_value => p_certification_status_code
441: );
442: --
443: hr_utility.set_location(' Step:'|| l_proc, 20);
444: IF hr_api.not_exists_in_hr_lookups
445: (p_effective_date => p_effective_date
446: ,p_lookup_type => 'OTA_CERT_ENROLL_STATUS'
447: ,p_lookup_code => p_certification_status_code
448: ) THEN

Line 562: FROM hr_lookups

558: AND cre.certification_status_code <> 'CANCELLED';
559:
560: CURSOR csr_get_object_type IS
561: SELECT meaning
562: FROM hr_lookups
563: WHERE lookup_type = 'OTA_OBJECT_TYPE'
564: and lookup_code = 'CRT';
565:
566: l_person_name per_all_people_f.full_name%TYPE;