APPS.OTA_BULK_ENROLL_UTIL dependencies on HR_LOOKUPS

Line 17: hr_lookups lkp

13: SELECT lpe.path_status_code status_code,
14: lkp.meaning Status_meaning,
15: decode(lpe.path_status_code,'CANCELLED' , 0, 'ACTIVE',1, 'COMPLETED', 2) path_status_number
16: FROM ota_lp_enrollments lpe,
17: hr_lookups lkp
18: WHERE lpe.learning_path_id = p_object_id
19: AND lpe.person_id = p_learner_id
20: AND lkp.lookup_code = lpe.path_status_code
21: AND lkp.lookup_type = 'OTA_LEARNING_PATH_STATUS'

Line 46: hr_lookups lkp

42: lkp.meaning Status_meaning,
43: decode(cre.certification_status_code, 'REJECTED', 0, 'EXPIRED', 1, 'AWAITING_APPROVAL',2,
44: 'CERTIFIED' , 3, 'CONCLUDED', 4,'ENROLLED',5) cert_status_number
45: FROM ota_cert_enrollments cre,
46: hr_lookups lkp
47: WHERE cre.certification_id = p_object_id
48: AND cre.person_id = p_learner_id
49: AND lkp.lookup_code =cre.certification_status_code
50: AND lkp.lookup_type = 'OTA_CERT_ENROLL_STATUS'

Line 92: FROM hr_lookups lkp

88: AND btt.booking_status_type_id = p_enrollment_status;
89:
90: CURSOR get_subscription_status IS
91: SELECT lkp.meaning
92: FROM hr_lookups lkp
93: WHERE lkp.lookup_code = p_enrollment_status
94: AND lkp.lookup_type = decode(p_object_type,'LP','OTA_LEARNING_PATH_STATUS','CRT','OTA_CERT_ENROLL_STATUS');
95:
96: l_status VARCHAR2(100) := null;