888: -- Get the Courses Linked to a Certification
889: cursor csr_get_cert_courses(p_cert_id number) is
890: select ocm.object_id
891: from OTA_CERTIFICATION_MEMBERS ocm
892: , OTA_CERTIFICATIONS_B oc
893: where oc.certification_id = p_cert_id
894: and ocm.certification_id = oc.certification_id
895: and ocm.object_type = 'H';
896: --
2972: --
2973: -- Certifications
2974: cursor csr_wsp_cert(p_person_id number) is
2975: select oc.certification_id, oc_tl.name
2976: from ota_certifications_b oc
2977: ,ota_certifications_tl oc_tl
2978: ,ota_cert_enrollments oce
2979: where oce.person_id = p_person_id
2980: and oce.certification_id = oc.certification_id
3043: -- Get the Courses Linked to a Certification
3044: cursor csr_get_cert_courses(p_cert_id number) is
3045: select ocm.object_id
3046: from OTA_CERTIFICATION_MEMBERS ocm
3047: , OTA_CERTIFICATIONS_B oc
3048: where oc.certification_id = p_cert_id
3049: and ocm.certification_id = oc.certification_id
3050: and ocm.object_type = 'H';
3051: --
3083: --
3084: cursor csr_exists_cert_courses(p_cert_id number) is
3085: select count(ocm.object_id)
3086: from OTA_CERTIFICATION_MEMBERS ocm
3087: , OTA_CERTIFICATIONS_B oc
3088: where oc.certification_id = p_cert_id
3089: and ocm.certification_id = oc.certification_id
3090: and ocm.object_type = 'H';
3091: --
3610: --
3611: -- Certifications
3612: cursor csr_atr_cert(p_person_id number) is
3613: select oc.certification_id, oc_tl.name,oce.completion_date, oce.certification_status_code
3614: from ota_certifications_b oc
3615: ,ota_certifications_tl oc_tl
3616: ,ota_cert_enrollments oce
3617: where oce.person_id = p_person_id
3618: and oce.certification_id = oc.certification_id