APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 157: FROM ams_event_offers_all_b

153:
154: --check for the parent event
155: CURSOR c_check_parent_event(l_act_metric_used_by_id NUMBER) IS
156: SELECT event_header_id
157: FROM ams_event_offers_all_b
158: WHERE event_offer_id = l_act_metric_used_by_id;
159: l_parent_obj NUMBER;
160:
161: -- 06/24/2001 huili added

Line 165: FROM ams_event_offers_all_b

161: -- 06/24/2001 huili added
162: --check for the parent event
163: CURSOR c_check_parent_event_o(l_act_metric_used_by_id NUMBER) IS
164: SELECT event_header_id
165: FROM ams_event_offers_all_b
166: WHERE event_offer_id = l_act_metric_used_by_id;
167:
168: --check for the parent event
169: CURSOR c_check_parent_event_h(l_act_metric_used_by_id NUMBER) IS

Line 196: FROM ams_event_offers_all_b

192: WHERE schedule_id = l_act_metric_used_by_id;
193:
194: CURSOR c_check_parent_one_event(l_act_metric_used_by_id NUMBER) IS
195: SELECT parent_id
196: FROM ams_event_offers_all_b
197: WHERE event_offer_id = l_act_metric_used_by_id
198: AND parent_type = 'RCAM';
199: -- END
200:

Line 1241: FROM ams_event_offers_all_b

1237: AND system_status_code = 'CANCELLED';
1238:
1239: CURSOR c_eveo(id NUMBER) IS
1240: SELECT Fnd_Api.G_TRUE
1241: FROM ams_event_offers_all_b
1242: WHERE event_offer_id = id
1243: AND system_status_code IN ('CANCELLED');
1244:
1245: l_is_canceled VARCHAR2(1) := Fnd_Api.G_FALSE;

Line 2534: FROM AMS_EVENT_OFFERS_ALL_B

2530: WHERE EVENT_HEADER_ID = p_event_id;
2531:
2532: CURSOR c_get_eveo_setup(p_event_offer_id NUMBER) IS
2533: SELECT setup_type_id
2534: FROM AMS_EVENT_OFFERS_ALL_B
2535: WHERE EVENT_OFFER_ID = p_event_offer_id;
2536:
2537: CURSOR c_get_delv_setup(p_deliverable_id NUMBER) IS
2538: SELECT custom_setup_id