APPS.OTA_LO_UTILITY dependencies on OTA_CERTIFICATION_MEMBERS

Line 563: from ota_certification_members cm, ota_cert_mbr_enrollments cme,

559: cme.member_status_code,
560: cme.object_version_number,
561: cme.cert_member_id,
562: cme.cert_prd_enrollment_id
563: from ota_certification_members cm, ota_cert_mbr_enrollments cme,
564: ota_offerings o, ota_cert_prd_enrollments cpe
565: where
566: cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
567: and cme.cert_member_id = cm.certification_member_id

Line 1253: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme

1249: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1250:
1251: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1252: select o.learning_object_id
1253: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1254: where o.activity_version_id = cm.object_id
1255: and cm.certification_member_id = cme.cert_member_id
1256: and cme.cert_prd_enrollment_id = p_cert_prd_enroll_id;
1257:

Line 3821: FROM ota_certification_members cmb,

3817: cme.object_version_number,
3818: cmb.object_id,
3819: cmb.certification_member_id,
3820: cme.member_status_code
3821: FROM ota_certification_members cmb,
3822: ota_cert_mbr_enrollments cme,
3823: ota_cert_prd_enrollments cpe
3824: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
3825: AND cme.cert_member_id = cmb.certification_member_id

Line 4109: from ota_certification_members cmb,

4105: AND cert_prd_enrollment_id = csr_cert_prd_enrollment_id;
4106:
4107: cursor csr_get_act is
4108: select cmb.object_id
4109: from ota_certification_members cmb,
4110: ota_cert_mbr_enrollments cme
4111: where cmb.certification_member_id = cme.cert_member_id
4112: and cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
4113: and cmb.object_type = 'H';

Line 4237: FROM ota_certification_members cmb,

4233: cme.object_version_number,
4234: cmb.object_id,
4235: cmb.certification_member_id,
4236: cme.member_status_code
4237: FROM ota_certification_members cmb,
4238: ota_cert_mbr_enrollments cme,
4239: ota_cert_prd_enrollments cpe
4240: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4241: AND cme.cert_member_id = cmb.certification_member_id

Line 4857: OTA_CERTIFICATION_MEMBERS cmb,

4853: OTA_CERTIFICATIONS_B crt,
4854: OTA_CERT_ENROLLMENTS cre,
4855: OTA_CERT_PRD_ENROLLMENTS cpe,
4856: OTA_CERT_MBR_ENROLLMENTS cme,
4857: OTA_CERTIFICATION_MEMBERS cmb,
4858: OTA_EVENTS evt
4859: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
4860: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID
4861: AND (cmb.OBJECT_TYPE = 'H' AND cmb.OBJECT_ID = evt.activity_version_id)