APPS.OZF_UTILITY_PVT dependencies on AMS_DELIVERABLES_VL

Line 741: x_table_name := 'AMS_DELIVERABLES_VL';

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';
743: ELSIF (p_sys_qual ='AMET') THEN
744: x_table_name := 'OZF_ACT_METRICS_ALL';
745: x_pk_name := 'ACTIVITY_METRIC_ID';

Line 884: FROM ams_deliverables_vl

880: AND s.campaign_id = c.campaign_id;
881:
882: CURSOR c_deliv(p_object_id IN NUMBER) IS
883: SELECT deliverable_name
884: FROM ams_deliverables_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

Line 3056: FROM ams_deliverables_vl

3052:
3053: CURSOR Cur_Delv(p_delv_id IN NUMBER)
3054: IS
3055: SELECT deliverable_name
3056: FROM ams_deliverables_vl
3057: WHERE deliverable_id = p_delv_id;
3058:
3059:
3060: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_NAME';