APPS.OTA_LPE_BUS dependencies on HR_LOOKUPS

Line 516: IF hr_api.not_exists_in_hr_lookups

512: ,p_argument_value => p_path_status_code
513: );
514: --
515: hr_utility.set_location(' Step:'|| l_proc, 20);
516: IF hr_api.not_exists_in_hr_lookups
517: (p_effective_date => p_effective_date
518: ,p_lookup_type => 'OTA_LEARNING_PATH_STATUS'
519: ,p_lookup_code => p_path_status_code
520: ) THEN

Line 564: IF hr_api.not_exists_in_hr_lookups

560: ,p_argument_value => p_enrollment_source_code
561: );
562: --
563: hr_utility.set_location(' Step:'|| l_proc, 20);
564: IF hr_api.not_exists_in_hr_lookups
565: (p_effective_date => p_effective_date
566: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
567: ,p_lookup_code => p_enrollment_source_code
568: ) THEN

Line 660: FROM hr_lookups

656: AND lpe.path_status_code <> 'CANCELLED';
657:
658: CURSOR csr_get_object_type IS
659: SELECT meaning
660: FROM hr_lookups
661: WHERE lookup_type = 'OTA_OBJECT_TYPE'
662: and lookup_code = 'LP';
663:
664: l_person_name per_all_people_f.full_name%TYPE;