DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_GENERAL

Line 76: AND evt.business_group_id = OTA_GENERAL.get_business_group_id

72: AND decode(evt.enrolment_end_date, NULL, to_date('4712/12/31','YYYY/MM/DD'),
73: to_date( to_char(evt.enrolment_end_date, 'YYYY/MM/DD') || ' ' || '23:59', 'YYYY/MM/DD HH24:MI'))
74: AND evt.event_status IN ('P','N')
75: AND nvl(p_event_id,-1)= decode(p_event_id,NULL,-1,evt.EVENT_ID)
76: AND evt.business_group_id = OTA_GENERAL.get_business_group_id
77: ORDER BY evt.event_id;
78:
79: FORALL i IN 1 .. l_rec.event_id.COUNT
80: