APPS.AMS_EVHRULES_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 159: FROM ams_event_headers_vl

155: )
156: IS
157: CURSOR c_evh IS
158: SELECT *
159: FROM ams_event_headers_vl
160: WHERE event_header_id = p_evh_rec.event_header_id;
161:
162: CURSOR c_source_code IS
163: SELECT 1

Line 340: FROM ams_event_headers_vl

336: FROM ams_campaigns_vl
337: WHERE campaign_id = p_fund_source_id;
338: CURSOR c_eveh IS
339: SELECT 1
340: FROM ams_event_headers_vl
341: WHERE event_header_id = p_fund_source_id;
342: CURSOR c_eveo IS
343: SELECT 1
344: FROM ams_event_offers_vl

Line 592: FROM ams_event_headers_vl

588: l_source_code_id NUMBER;
589:
590: CURSOR c_old_info IS
591: SELECT global_flag, source_code
592: FROM ams_event_headers_vl
593: WHERE event_header_id = p_evh_id;
594:
595: CURSOR c_source_code IS
596: SELECT source_code_id

Line 2668: FROM ams_event_headers_vl

2664: AND system_status_code = 'AVAILABLE';
2665:
2666: CURSOR c_header_obj_ver IS
2667: SELECT object_version_number
2668: FROM ams_event_headers_vl
2669: WHERE event_header_id = p_event_header_id;
2670:
2671: CURSOR c_no_schedule IS
2672: SELECT count(*)

Line 2679: FROM ams_event_headers_vl

2675: AND system_status_code NOT IN ( 'CANCELLED', 'ARCHIVED');
2676:
2677: CURSOR c_header_status IS
2678: SELECT system_status_code
2679: FROM ams_event_headers_vl
2680: WHERE event_header_id = p_event_header_id;
2681:
2682:
2683: BEGIN