DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_CERTIFICATION_MEMBERS

Line 2304: AND exists (select 1 from ota_certification_members crm where cert.certification_id = crm.certification_id)

2300: AND nvl(p_cert_id,-1)= decode(p_cert_id,NULL,-1,cert.certification_id)
2301: AND ((cert.renewable_flag = 'N' and trunc(sysdate) <= nvl( cert.INITIAL_COMPLETION_DATE ,trunc(sysdate)))
2302: or cert.renewable_flag = 'Y')
2303: AND cert.business_group_id = OTA_GENERAL.get_business_group_id
2304: AND exists (select 1 from ota_certification_members crm where cert.certification_id = crm.certification_id)
2305: ORDER BY cert.certification_id;
2306:
2307:
2308: