DBA Data[Home] [Help]

APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 883: FROM ams_event_headers_vl

879: AND media_id = p_media_id;
880:
881: CURSOR c_eveh IS
882: SELECT event_type_code
883: FROM ams_event_headers_vl
884: WHERE event_header_id = p_channel_id;
885:
886: CURSOR c_eveo IS
887: SELECT event_type_code

Line 1032: FROM ams_event_headers_vl

1028: WHERE campaign_id = p_fund_source_id;
1029:
1030: CURSOR c_eveh IS
1031: SELECT 1
1032: FROM ams_event_headers_vl
1033: WHERE event_header_id = p_fund_source_id;
1034:
1035: CURSOR c_eveo IS
1036: SELECT 1

Line 1703: FROM ams_event_headers_vl

1699: CURSOR c_sub_eveh IS
1700: SELECT event_header_name AS event_name,
1701: active_from_date AS start_date,
1702: active_to_date AS end_date
1703: FROM ams_event_headers_vl
1704: WHERE program_id = p_camp_id;
1705:
1706: CURSOR c_sub_eone IS
1707: SELECT event_offer_name AS event_name,