DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 738: x_table_name := 'AMS_EVENT_HEADERS_VL';

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';
740: ELSIF (p_sys_qual ='DELV') THEN
741: x_table_name := 'AMS_DELIVERABLES_VL';
742: x_pk_name := 'DELIVERABLE_ID';

Line 854: -- to ams_event_headers_vl.

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
858: -- 15-Jun-2001 choang changed PRNT to PTNR

Line 889: FROM ams_event_headers_vl

885: WHERE deliverable_id = p_object_id;
886:
887: CURSOR c_event_header(p_object_id IN NUMBER) IS
888: SELECT event_header_name
889: FROM ams_event_headers_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