DBA Data[Home] [Help]

APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 3316: FROM ams_event_offers_all_b

3312: WHERE event_header_id = p_related_event_id ;
3313:
3314: CURSOR c_schedule_event IS
3315: SELECT event_offer_id
3316: FROM ams_event_offers_all_b
3317: WHERE event_offer_id = p_related_event_id
3318: --AND event_standalone_flag = 'N';
3319: AND event_object_type = 'EVEO';
3320:

Line 3323: FROM ams_event_offers_all_b

3319: AND event_object_type = 'EVEO';
3320:
3321: CURSOR c_one_off_event IS
3322: SELECT event_offer_id
3323: FROM ams_event_offers_all_b
3324: WHERE event_offer_id = p_related_event_id
3325: --AND event_standalone_flag = 'Y';
3326: AND event_object_type = 'EONE';
3327:

Line 4181: FROM ams_event_offers_all_b

4177: WHERE event_header_id = p_event_id ;
4178:
4179: CURSOR c_fetch_sourcecode_for_eveo IS
4180: SELECT source_code
4181: FROM ams_event_offers_all_b
4182: WHERE event_offer_id = p_event_id
4183: --AND event_standalone_flag = 'N';
4184: AND event_object_type = 'EVEO';
4185:

Line 4188: FROM ams_event_offers_all_b

4184: AND event_object_type = 'EVEO';
4185:
4186: CURSOR c_fetch_sourcecode_for_eone IS
4187: SELECT source_code
4188: FROM ams_event_offers_all_b
4189: WHERE event_offer_id = p_event_id
4190: --AND event_standalone_flag = 'Y';
4191: AND event_object_type = 'EONE';
4192: