APPS.OTA_CPE_BUS dependencies on OTA_CERTIFICATION_MEMBERS

Line 413: from ota_certification_members cmb,

409:
410: CURSOR csr_cert_mbr IS
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

Line 421: l_CERTIFICATION_MEMBER_ID ota_certification_members.CERTIFICATION_MEMBER_ID%type;

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'));
420:
421: l_CERTIFICATION_MEMBER_ID ota_certification_members.CERTIFICATION_MEMBER_ID%type;
422: --
423: BEGIN
424: --
425: -- check mandatory parameters have been set