DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on AMS_EVENT_HEADERS_VL

Line 721: x_table_name := 'AMS_EVENT_HEADERS_VL';

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';
723: ELSIF (p_sys_qual ='DELV') THEN
724: x_table_name := 'AMS_DELIVERABLES_VL';
725: x_pk_name := 'DELIVERABLE_ID';

Line 837: -- to ams_event_headers_vl.

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

Line 872: FROM ams_event_headers_vl

868: WHERE deliverable_id = p_object_id;
869:
870: CURSOR c_event_header(p_object_id IN NUMBER) IS
871: SELECT event_header_name
872: FROM ams_event_headers_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