APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_CERTIFICATIONS_TL

Line 1151: FROM ota_certifications_tl

1147: AND language = USERENV('LANG');
1148:
1149: CURSOR csr_get_cert_name IS
1150: SELECT name
1151: FROM ota_certifications_tl
1152: WHERE certification_id = p_object_id
1153: AND language = USERENV('LANG');
1154:
1155: CURSOR csr_get_class_name IS

Line 1163: l_cert_name OTA_CERTIFICATIONS_TL.NAME%TYPE := NULL;

1159: AND language = USERENV('LANG');
1160:
1161: l_class_name OTA_EVENTS_TL.TITLE%TYPE := NULL;
1162: l_lp_name OTA_LEARNING_PATHS_TL.NAME%TYPE := NULL;
1163: l_cert_name OTA_CERTIFICATIONS_TL.NAME%TYPE := NULL;
1164: BEGIN
1165: IF p_object_type in ('CL','LPCL','CLU') THEN ----modified for 12426494
1166: OPEN csr_get_class_name;
1167: FETCH csr_get_class_name INTO l_class_name;