APPS.AMS_CPYUTILITY_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 194: FROM ams_event_offers_vl

190: l_name VARCHAR2 (240);
191:
192: CURSOR c_eveo_name(p_event_offering_id IN NUMBER) IS
193: SELECT event_offer_name
194: FROM ams_event_offers_vl
195: WHERE event_offer_id = p_event_offering_id;
196:
197: BEGIN
198:

Line 465: FROM AMS_EVENT_OFFERS_VL

461:
462: ELSIF p_arc_act_code = 'EVEO' THEN
463: SELECT event_end_date,event_start_date
464: INTO end_date,start_date
465: FROM AMS_EVENT_OFFERS_VL
466: WHERE event_offer_id = p_activity_id;
467: l_number := (end_date - start_date);
468:
469: ELSIF p_arc_act_code = 'EVEH' THEN