APPS.OTA_CPE_BUS dependencies on OTA_CERT_ENROLLMENTS

Line 405: ( p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE)

401: -- |-----------------------------------------------|
402: -- ----------------------------------------------------------------------------
403: --
404: PROCEDURE check_active_cert_members
405: ( p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE)
406: IS
407: --
408: l_proc varchar2(72) := g_package|| 'check_active_cert_members';
409:

Line 415: ota_cert_enrollments cre

411: select
412: cmb.CERTIFICATION_MEMBER_ID
413: from ota_certification_members cmb,
414: ota_certifications_b crt,
415: ota_cert_enrollments cre
416: where cre.cert_enrollment_id = p_cert_enrollment_id
417: and cre.certification_id = crt.certification_id
418: and crt.certification_id = cmb.certification_id
419: and trunc(sysdate) between trunc(cmb.START_DATE_ACTIVE) and nvl(trunc(cmb.end_date_active), to_date('4712/12/31', 'YYYY/MM/DD'));