APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on OTA_CERTIFICATION_MEMBERS

Line 59: FROM ota_certification_members

55: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
56:
57: CURSOR csr_get_course_id IS
58: SELECT object_id
59: FROM ota_certification_members
60: WHERE certification_member_id = p_cert_member_id;
61:
62: l_mode varchar2(1);
63:

Line 289: FROM ota_certification_members cmb,

285:
286: CURSOR csr_get_course_id IS
287: SELECT cmb.object_id,
288: cpe.cert_prd_enrollment_id
289: FROM ota_certification_members cmb,
290: ota_cert_mbr_enrollments cme,
291: ota_cert_prd_enrollments cpe
292: WHERE cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
293: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id