APPS.OZF_UTILITY_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 715: x_table_name := 'AMS_EVENT_OFFERS_VL';

711: -- End of code modified by ptendulk on 30-Jan-2001
712: x_table_name := 'AMS_CAMPAIGNS_ALL_B';
713: x_pk_name := 'CAMPAIGN_ID';
714: ELSIF (p_sys_qual ='EVEO') THEN
715: x_table_name := 'AMS_EVENT_OFFERS_VL';
716: x_pk_name := 'EVENT_OFFER_ID';
717: ELSIF (p_sys_qual ='EONE') THEN
718: x_table_name := 'AMS_EVENT_OFFERS_VL';
719: x_pk_name := 'EVENT_OFFER_ID';

Line 718: x_table_name := 'AMS_EVENT_OFFERS_VL';

714: ELSIF (p_sys_qual ='EVEO') THEN
715: x_table_name := 'AMS_EVENT_OFFERS_VL';
716: x_pk_name := 'EVENT_OFFER_ID';
717: ELSIF (p_sys_qual ='EONE') THEN
718: x_table_name := 'AMS_EVENT_OFFERS_VL';
719: x_pk_name := 'EVENT_OFFER_ID';
720: ELSIF (p_sys_qual ='EVEH') THEN
721: x_table_name := 'AMS_EVENT_HEADERS_VL';
722: x_pk_name := 'EVENT_HEADER_ID';

Line 836: -- ams_event_offers_vl and ozf_event_headers_all_vl

832: -- 10/15/99 holiu Created.
833: -- 11/03/99 mpande inserted deliverable,event
834: -- 11/16/99 tdonohoe inserted campaign schedule.
835: -- 09-Dec-1999 choang Changed references of ozf_event_offers_all_vl to
836: -- ams_event_offers_vl and ozf_event_headers_all_vl
837: -- to ams_event_headers_vl.
838: -- 24-Aug-2000 choang Added FUND
839: -- 28-Sep-2000 choang Added PRTN
840: -- 13-Jun-2001 ptendulk Added EONE

Line 877: FROM ams_event_offers_vl

873: WHERE event_header_id = p_object_id;
874:
875: CURSOR c_event_offer(p_object_id IN NUMBER) IS
876: SELECT event_offer_name
877: FROM ams_event_offers_vl
878: WHERE event_offer_id = p_object_id;
879: --- updated by mpande 01/30/2001 to look into ozf_funds_all_vl not ozf_funds_vl
880: CURSOR c_fund (p_object_id IN NUMBER) IS
881: SELECT short_name