APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 1372: -- FROM ams_event_offers_all_b

1368: -- WHERE event_header_id = p_channel_id;
1369: --
1370: -- CURSOR c_eveo IS
1371: -- SELECT event_type_code
1372: -- FROM ams_event_offers_all_b
1373: -- WHERE event_offer_id = p_channel_id;
1374:
1375: -- CURSOR c_camp_event IS
1376: -- SELECT 1

Line 3171: UPDATE ams_event_offers_all_b

3167:
3168: END IF;
3169: -- Not handling return_stauts here
3170:
3171: UPDATE ams_event_offers_all_b
3172: SET user_status_id = l_new_status_id,
3173: system_status_code = p_new_status_code,
3174: last_status_date = SYSDATE
3175: WHERE event_offer_id = l_related_event_id;