APPS.OTA_CMB_BUS dependencies on OTA_CERTIFICATIONS_B

Line 463: FROM ota_certifications_b

459: CURSOR csr_cert_start_end_date is
460: SELECT
461: start_date_active,
462: nvl(end_date_active, to_date('31-12-4712', 'DD-MM-YYYY'))
463: FROM ota_certifications_b
464: WHERE certification_id = p_certification_id;
465:
466: --
467: -- Variables

Line 745: p_certification_id ota_certifications_b.certification_id%type) is

741: end_date_active > sysdate);
742:
743: cursor csr_cmb_exists(
744: p_cert_mbr_id ota_certification_members.certification_member_id%type,
745: p_certification_id ota_certifications_b.certification_id%type) is
746: select 'Y'
747: from ota_certification_members cmb
748: where cmb.certification_id = p_certification_id
749: and cmb.certification_member_id <> p_cert_mbr_id