APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on OTA_CERTIFICATION_MEMBERS

Line 60: FROM ota_certification_members

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

Line 291: FROM ota_certification_members cmb,

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