APPS.OZF_UTILITY_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 732: x_table_name := 'AMS_EVENT_OFFERS_VL';

728: -- End of code modified by ptendulk on 30-Jan-2001
729: x_table_name := 'AMS_CAMPAIGNS_ALL_B';
730: x_pk_name := 'CAMPAIGN_ID';
731: ELSIF (p_sys_qual ='EVEO') THEN
732: x_table_name := 'AMS_EVENT_OFFERS_VL';
733: x_pk_name := 'EVENT_OFFER_ID';
734: ELSIF (p_sys_qual ='EONE') THEN
735: x_table_name := 'AMS_EVENT_OFFERS_VL';
736: x_pk_name := 'EVENT_OFFER_ID';

Line 735: x_table_name := 'AMS_EVENT_OFFERS_VL';

731: ELSIF (p_sys_qual ='EVEO') THEN
732: x_table_name := 'AMS_EVENT_OFFERS_VL';
733: x_pk_name := 'EVENT_OFFER_ID';
734: ELSIF (p_sys_qual ='EONE') THEN
735: x_table_name := 'AMS_EVENT_OFFERS_VL';
736: x_pk_name := 'EVENT_OFFER_ID';
737: ELSIF (p_sys_qual ='EVEH') THEN
738: x_table_name := 'AMS_EVENT_HEADERS_VL';
739: x_pk_name := 'EVENT_HEADER_ID';

Line 853: -- ams_event_offers_vl and ozf_event_headers_all_vl

849: -- 10/15/99 holiu Created.
850: -- 11/03/99 mpande inserted deliverable,event
851: -- 11/16/99 tdonohoe inserted campaign schedule.
852: -- 09-Dec-1999 choang Changed references of ozf_event_offers_all_vl to
853: -- ams_event_offers_vl and ozf_event_headers_all_vl
854: -- to ams_event_headers_vl.
855: -- 24-Aug-2000 choang Added FUND
856: -- 28-Sep-2000 choang Added PRTN
857: -- 13-Jun-2001 ptendulk Added EONE

Line 894: FROM ams_event_offers_vl

890: WHERE event_header_id = p_object_id;
891:
892: CURSOR c_event_offer(p_object_id IN NUMBER) IS
893: SELECT event_offer_name
894: FROM ams_event_offers_vl
895: WHERE event_offer_id = p_object_id;
896: --- updated by mpande 01/30/2001 to look into ozf_funds_all_vl not ozf_funds_vl
897: CURSOR c_fund (p_object_id IN NUMBER) IS
898: SELECT short_name