DBA Data[Home] [Help]

APPS.AMS_EVENTSCHEDULE_COPY_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 42: FROM ams_event_offers_vl

38: -- PL/SQL Block
39: l_name VARCHAR2 (256);
40: CURSOR c_agenda_name(p_agenda_id IN NUMBER) IS
41: SELECT event_offer_name
42: FROM ams_event_offers_vl
43: WHERE parent_event_offer_id = p_agenda_id;
44:
45: BEGIN
46:

Line 369: FROM ams_event_offers_vl

365: ,publish_flag
366: ,meeting_encryption_key_code
367: ,number_of_attendees
368: ,EVENT_PURPOSE_CODE
369: FROM ams_event_offers_vl
370: WHERE parent_event_offer_id = p_src_act_id
371: AND event_level='SUB';
372: BEGIN
373: p_errcode := NULL;

Line 881: FROM ams_event_offers_vl

877: WHERE act_delivery_method_used_by_id = event_offer_id;
878:
879: CURSOR c_event_times( event_offer_id_in IN NUMBER) IS
880: SELECT event_start_date, event_end_date
881: FROM ams_event_offers_vl
882: WHERE event_offer_id = event_offer_id_in;
883:
884:
885: BEGIN