APPS.OTA_CERT_ENROLLMENT_API dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 646: FROM ota_cert_prd_enrollments

642: where cert_enrollment_id = p_cert_enrollment_id;
643:
644: CURSOR csr_prd_enrl(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
645: select cert_prd_enrollment_id, period_status_code, object_version_number, completion_date
646: FROM ota_cert_prd_enrollments
647: where cert_enrollment_id = p_cert_enrollment_id
648: and trunc(sysdate) between trunc(cert_period_start_date) and nvl(trunc(cert_period_end_date),trunc(sysdate))
649: order by cert_prd_enrollment_id desc;
650:

Line 653: FROM ota_cert_prd_enrollments

649: order by cert_prd_enrollment_id desc;
650:
651: CURSOR csr_cpe_exist(p_cert_enrollment_id in ota_cert_enrollments.cert_enrollment_id%type) IS
652: select cert_prd_enrollment_id
653: FROM ota_cert_prd_enrollments
654: where cert_enrollment_id = p_cert_enrollment_id;
655:
656:
657: l_proc varchar2(72) := g_package || ' subscribe_to_certification';