APPS.AMS_EVHRULES_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 344: FROM ams_event_offers_vl

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
345: WHERE event_offer_id = p_fund_source_id;
346: CURSOR c_eone IS
347: SELECT 1
348: FROM ams_event_offers_vl

Line 348: FROM ams_event_offers_vl

344: FROM ams_event_offers_vl
345: WHERE event_offer_id = p_fund_source_id;
346: CURSOR c_eone IS
347: SELECT 1
348: FROM ams_event_offers_vl
349: WHERE event_offer_id = p_fund_source_id;
350: BEGIN
351: x_return_status := FND_API.g_ret_sts_success;
352: IF p_fund_source_type IS NULL AND p_fund_source_id IS NULL THEN

Line 719: FROM ams_event_offers_vl

715: l_source_code_id NUMBER;
716:
717: CURSOR c_old_info IS
718: SELECT global_flag, source_code
719: FROM ams_event_offers_vl
720: WHERE event_offer_id = p_evo_id;
721:
722: CURSOR c_source_code IS
723: SELECT source_code_id

Line 849: FROM ams_event_offers_vl

845: l_source_code_id NUMBER;
846:
847: CURSOR c_old_info IS
848: SELECT global_flag, source_code
849: FROM ams_event_offers_vl
850: WHERE event_offer_id = p_evo_id;
851:
852: CURSOR c_source_code IS
853: SELECT source_code_id

Line 1943: FROM ams_event_offers_vl

1939: l_act_list_header_id NUMBER ;
1940:
1941: CURSOR c_evnt_name_exist(name_in in VARCHAR2) IS
1942: SELECT count(event_offer_name)
1943: FROM ams_event_offers_vl
1944: WHERE event_offer_name = name_in;
1945: BEGIN
1946: null;
1947: /*

Line 2662: FROM ams_event_offers_vl

2658:
2659: -- Modified the select statement of the cursor to get event_object_type, as per enh # 3805347
2660: CURSOR c_schedule IS
2661: SELECT event_offer_id , object_version_number, event_object_type
2662: FROM ams_event_offers_vl
2663: WHERE event_header_id = p_event_header_id
2664: AND system_status_code = 'AVAILABLE';
2665:
2666: CURSOR c_header_obj_ver IS

Line 2673: FROM ams_event_offers_vl

2669: WHERE event_header_id = p_event_header_id;
2670:
2671: CURSOR c_no_schedule IS
2672: SELECT count(*)
2673: FROM ams_event_offers_vl
2674: WHERE event_header_id = p_event_header_id
2675: AND system_status_code NOT IN ( 'CANCELLED', 'ARCHIVED');
2676:
2677: CURSOR c_header_status IS