APPS.OTA_CERT_ENROLLMENT_API dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 665: FROM ota_cert_prd_enrollments

661: where cert_enrollment_id = p_cert_enrollment_id;
662:
663: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
664: select cert_prd_enrollment_id, period_status_code, object_version_number, completion_date
665: FROM ota_cert_prd_enrollments
666: where cert_enrollment_id = p_cert_enrollment_id
667: and trunc(sysdate) between trunc(cert_period_start_date) and nvl(trunc(cert_period_end_date),trunc(sysdate))
668: and period_status_code = 'ACTIVE' --Bug#7705069
669: order by cert_prd_enrollment_id desc;

Line 673: FROM ota_cert_prd_enrollments

669: order by cert_prd_enrollment_id desc;
670:
671: CURSOR csr_cpe_exist(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
672: select cert_prd_enrollment_id
673: FROM ota_cert_prd_enrollments
674: where cert_enrollment_id = p_cert_enrollment_id;
675:
676:
677: l_proc varchar2(72) := g_package || ' subscribe_to_certification';