APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on OTA_CERTIFICATIONS_B

Line 891: , OTA_CERTIFICATIONS_B oc

887: -- Get the Courses Linked to a Certification
888: cursor csr_get_cert_courses(p_cert_id number) is
889: select ocm.object_id
890: from OTA_CERTIFICATION_MEMBERS ocm
891: , OTA_CERTIFICATIONS_B oc
892: where oc.certification_id = p_cert_id
893: and ocm.certification_id = oc.certification_id
894: and ocm.object_type = 'H';
895: --

Line 2970: from ota_certifications_b oc

2966: --
2967: -- Certifications
2968: cursor csr_wsp_cert(p_person_id number) is
2969: select oc.certification_id, oc_tl.name
2970: from ota_certifications_b oc
2971: ,ota_certifications_tl oc_tl
2972: ,ota_cert_enrollments oce
2973: where oce.person_id = p_person_id
2974: and oce.certification_id = oc.certification_id

Line 3041: , OTA_CERTIFICATIONS_B oc

3037: -- Get the Courses Linked to a Certification
3038: cursor csr_get_cert_courses(p_cert_id number) is
3039: select ocm.object_id
3040: from OTA_CERTIFICATION_MEMBERS ocm
3041: , OTA_CERTIFICATIONS_B oc
3042: where oc.certification_id = p_cert_id
3043: and ocm.certification_id = oc.certification_id
3044: and ocm.object_type = 'H';
3045: --

Line 3081: , OTA_CERTIFICATIONS_B oc

3077: --
3078: cursor csr_exists_cert_courses(p_cert_id number) is
3079: select count(ocm.object_id)
3080: from OTA_CERTIFICATION_MEMBERS ocm
3081: , OTA_CERTIFICATIONS_B oc
3082: where oc.certification_id = p_cert_id
3083: and ocm.certification_id = oc.certification_id
3084: and ocm.object_type = 'H';
3085: --

Line 3608: from ota_certifications_b oc

3604: --
3605: -- Certifications
3606: cursor csr_atr_cert(p_person_id number) is
3607: select oc.certification_id, oc_tl.name,oce.completion_date, oce.certification_status_code
3608: from ota_certifications_b oc
3609: ,ota_certifications_tl oc_tl
3610: ,ota_cert_enrollments oce
3611: where oce.person_id = p_person_id
3612: and oce.certification_id = oc.certification_id