DBA Data[Home] [Help]

APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 888: FROM ams_event_offers_vl

884: WHERE event_header_id = p_channel_id;
885:
886: CURSOR c_eveo IS
887: SELECT event_type_code
888: FROM ams_event_offers_vl
889: WHERE event_offer_id = p_channel_id;
890:
891: CURSOR c_camp_event IS
892: SELECT 1

Line 1037: FROM ams_event_offers_vl

1033: WHERE event_header_id = p_fund_source_id;
1034:
1035: CURSOR c_eveo IS
1036: SELECT 1
1037: FROM ams_event_offers_vl
1038: WHERE event_offer_id = p_fund_source_id;
1039:
1040: BEGIN
1041:

Line 1710: FROM ams_event_offers_vl

1706: CURSOR c_sub_eone IS
1707: SELECT event_offer_name AS event_name,
1708: event_start_date AS start_date,
1709: event_end_date AS end_date
1710: FROM ams_event_offers_vl
1711: WHERE parent_type = 'RCAM'
1712: AND parent_id = p_camp_id
1713: AND event_standalone_flag = 'Y' ;
1714: