APPS.AMS_UTILITY_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 676: x_table_name := 'AMS_EVENT_OFFERS_VL';

672: -- End of code modified by ptendulk on 30-Jan-2001
673: x_table_name := 'AMS_CAMPAIGNS_ALL_B';
674: x_pk_name := 'CAMPAIGN_ID';
675: ELSIF (p_sys_qual ='EVEO') THEN
676: x_table_name := 'AMS_EVENT_OFFERS_VL';
677: x_pk_name := 'EVENT_OFFER_ID';
678: ELSIF (p_sys_qual ='EONE') THEN
679: x_table_name := 'AMS_EVENT_OFFERS_VL';
680: x_pk_name := 'EVENT_OFFER_ID';

Line 679: x_table_name := 'AMS_EVENT_OFFERS_VL';

675: ELSIF (p_sys_qual ='EVEO') THEN
676: x_table_name := 'AMS_EVENT_OFFERS_VL';
677: x_pk_name := 'EVENT_OFFER_ID';
678: ELSIF (p_sys_qual ='EONE') THEN
679: x_table_name := 'AMS_EVENT_OFFERS_VL';
680: x_pk_name := 'EVENT_OFFER_ID';
681: ELSIF (p_sys_qual ='EVEH') THEN
682: x_table_name := 'AMS_EVENT_HEADERS_VL';
683: x_pk_name := 'EVENT_HEADER_ID';

Line 799: -- ams_event_offers_vl and ams_event_headers_all_vl

795: -- 10/15/99 holiu Created.
796: -- 11/03/99 mpande inserted deliverable,event
797: -- 11/16/99 tdonohoe inserted campaign schedule.
798: -- 09-Dec-1999 choang Changed references of ams_event_offers_all_vl to
799: -- ams_event_offers_vl and ams_event_headers_all_vl
800: -- to ams_event_headers_vl.
801: -- 24-Aug-2000 choang Added FUND
802: -- 28-Sep-2000 choang Added PRTN
803: -- 13-Jun-2001 ptendulk Added EONE

Line 840: FROM ams_event_offers_vl

836: WHERE event_header_id = p_object_id;
837:
838: CURSOR c_event_offer(p_object_id IN NUMBER) IS
839: SELECT event_offer_name
840: FROM ams_event_offers_vl
841: WHERE event_offer_id = p_object_id;
842: --- updated by mpande 01/30/2001 to look into ozf_funds_all_vl not ozf_funds_vl
843: CURSOR c_fund (p_object_id IN NUMBER) IS
844: SELECT short_name