APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 171: FROM ams_event_headers_all_b

167:
168: --check for the parent event
169: CURSOR c_check_parent_event_h(l_act_metric_used_by_id NUMBER) IS
170: SELECT parent_event_header_id
171: FROM ams_event_headers_all_b
172: WHERE event_header_id = l_act_metric_used_by_id;
173:
174: -- 06/23/2001 huili changed the "c_check_event_camp"
175: -- 06/07/2001 huili added two cursors

Line 179: FROM ams_event_headers_all_b

175: -- 06/07/2001 huili added two cursors
176: --check another type of parent event: execution campaign
177: CURSOR c_check_event_camp (l_act_metric_used_by_id NUMBER) IS
178: SELECT program_id
179: FROM ams_event_headers_all_b
180: WHERE event_header_id = l_act_metric_used_by_id;
181:
182: CURSOR c_check_camp_type (l_camp_id NUMBER) IS
183: SELECT rollup_type

Line 1235: FROM ams_event_headers_all_b

1231: AND status_code = 'CANCELLED';
1232:
1233: CURSOR c_eveh(id NUMBER) IS
1234: SELECT Fnd_Api.G_TRUE
1235: FROM ams_event_headers_all_b
1236: WHERE event_header_id = id
1237: AND system_status_code = 'CANCELLED';
1238:
1239: CURSOR c_eveo(id NUMBER) IS

Line 2529: FROM AMS_EVENT_HEADERS_ALL_B

2525: WHERE schedule_id = p_schedule_id;
2526:
2527: CURSOR c_get_eveh_setup(p_event_id NUMBER) IS
2528: SELECT setup_type_id
2529: FROM AMS_EVENT_HEADERS_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