[Home] [Help]
8: FROM OTA_CERTIFICATIONS_B crt,
9: OTA_CERT_ENROLLMENTS cre,
10: OTA_CERT_PRD_ENROLLMENTS cpe,
11: OTA_CERT_MBR_ENROLLMENTS cme,
12: OTA_CERTIFICATION_MEMBERS cmb,
13: OTA_EVENTS evt
14: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
15: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID
16: AND cmb.OBJECT_TYPE = 'H'
39: FROM OTA_CERTIFICATIONS_B crt,
40: OTA_CERT_ENROLLMENTS cre,
41: OTA_CERT_PRD_ENROLLMENTS cpe,
42: OTA_CERT_MBR_ENROLLMENTS cme,
43: OTA_CERTIFICATION_MEMBERS cmb,
44: OTA_EVENTS evt
45: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
46: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID
47: AND cmb.OBJECT_TYPE = 'H'
230: cme.cert_member_id,
231: cme.cert_prd_enrollment_id,
232: nvl(act.eres_enabled,'N') sign_enabled,
233: cm.object_id
234: from ota_certification_members cm, ota_cert_mbr_enrollments cme,
235: ota_offerings o, ota_cert_prd_enrollments cpe, ota_activity_versions act
236: where
237: cme.cert_prd_enrollment_id = p_cert_prd_enrollment_id
238: and cme.cert_member_id = cm.certification_member_id
742: SELECT cre.CERTIFICATION_STATUS_CODE
743: FROM OTA_CERTIFICATIONS_B crt,
744: OTA_CERT_ENROLLMENTS cre,
745: OTA_CERT_MBR_ENROLLMENTS cme,
746: OTA_CERTIFICATION_MEMBERS cmb,
747: OTA_EVENTS evt
748: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
749: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID
750: AND cmb.OBJECT_TYPE = 'H'
761: SELECT cre.CERTIFICATION_STATUS_CODE
762: FROM OTA_CERTIFICATIONS_B crt,
763: OTA_CERT_ENROLLMENTS cre,
764: OTA_CERT_MBR_ENROLLMENTS cme,
765: OTA_CERTIFICATION_MEMBERS cmb,
766: OTA_EVENTS evt
767: WHERE crt.CERTIFICATION_ID = cre.CERTIFICATION_ID
768: AND crt.CERTIFICATION_ID = cmb.CERTIFICATION_ID
769: AND cmb.OBJECT_TYPE = 'H'
1555: p_lo_id ota_learning_objects.learning_object_id%type) return boolean is
1556:
1557: cursor root_los(p_cert_prd_enroll_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%type) is
1558: select o.learning_object_id
1559: from ota_offerings o, ota_certification_members cm, ota_cert_mbr_enrollments cme
1560: where o.activity_version_id = cm.object_id
1561: and cm.certification_member_id = cme.cert_member_id
1562: and cme.cert_prd_enrollment_id = p_cert_prd_enroll_id;
1563:
4393: cme.object_version_number,
4394: cmb.object_id,
4395: cmb.certification_member_id,
4396: cme.member_status_code
4397: FROM ota_certification_members cmb,
4398: ota_cert_mbr_enrollments cme,
4399: ota_cert_prd_enrollments cpe
4400: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4401: AND cme.cert_member_id = cmb.certification_member_id
4681: AND cert_prd_enrollment_id = csr_cert_prd_enrollment_id;
4682:
4683: cursor csr_get_act is
4684: select cmb.object_id
4685: from ota_certification_members cmb,
4686: ota_cert_mbr_enrollments cme
4687: where cmb.certification_member_id = cme.cert_member_id
4688: and cme.cert_mbr_enrollment_id = p_cert_mbr_enrollment_id
4689: and cmb.object_type = 'H';
4809: cme.object_version_number,
4810: cmb.object_id,
4811: cmb.certification_member_id,
4812: cme.member_status_code
4813: FROM ota_certification_members cmb,
4814: ota_cert_mbr_enrollments cme,
4815: ota_cert_prd_enrollments cpe
4816: WHERE cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
4817: AND cme.cert_member_id = cmb.certification_member_id
5545:
5546: CURSOR csr_is_cert_mbr_person IS
5547: SELECT cre.cert_enrollment_id
5548: FROM ota_cert_enrollments cre,
5549: ota_certification_members cmb,
5550: ota_events oev
5551: WHERE cre.person_id = p_person_id
5552: AND oev.event_id = p_event_id
5553: AND NVL(cre.is_history_flag, 'N') = 'N'
5559:
5560: CURSOR csr_is_cert_mbr_contact IS
5561: SELECT cre.cert_enrollment_id
5562: FROM ota_cert_enrollments cre,
5563: ota_certification_members cmb,
5564: ota_events oev
5565: WHERE cre.contact_id = p_contact_id
5566: AND oev.event_id = p_event_id
5567: AND NVL(cre.is_history_flag, 'N') = 'N'