APPS.OZF_UTILITY_PVT dependencies on AMS_DELIVERABLES_VL

Line 724: x_table_name := 'AMS_DELIVERABLES_VL';

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';
726: ELSIF (p_sys_qual ='AMET') THEN
727: x_table_name := 'OZF_ACT_METRICS_ALL';
728: x_pk_name := 'ACTIVITY_METRIC_ID';

Line 867: FROM ams_deliverables_vl

863: AND s.campaign_id = c.campaign_id;
864:
865: CURSOR c_deliv(p_object_id IN NUMBER) IS
866: SELECT deliverable_name
867: FROM ams_deliverables_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

Line 3034: FROM ams_deliverables_vl

3030:
3031: CURSOR Cur_Delv(p_delv_id IN NUMBER)
3032: IS
3033: SELECT deliverable_name
3034: FROM ams_deliverables_vl
3035: WHERE deliverable_id = p_delv_id;
3036:
3037:
3038: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_NAME';