APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_CERTIFICATIONS_TL

Line 108: ota_certifications_tl cert_tl

104: reqm.error_message error_message
105: FROM
106: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,
107: OTA_MAND_MULTI_ENR_REQUESTS requests,
108: ota_certifications_tl cert_tl
109: WHERE
110: cert_tl.certification_id = reqm.certification_id
111: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)
112: AND cert_tl.language=userenv('LANG')

Line 180: FROM OTA_CERTIFICATIONS_TL

176: p_cert_id IN NUMBER);
177:
178: CURSOR get_certification_name(p_cert_id IN NUMBER) IS
179: SELECT name
180: FROM OTA_CERTIFICATIONS_TL
181: WHERE certification_id = p_cert_id
182: AND source_lang=userenv('LANG');
183:
184: