APPS.AMS_UTILITY_PVT dependencies on AMS_DELIVERABLES_VL

Line 685: x_table_name := 'AMS_DELIVERABLES_VL';

681: ELSIF (p_sys_qual ='EVEH') THEN
682: x_table_name := 'AMS_EVENT_HEADERS_VL';
683: x_pk_name := 'EVENT_HEADER_ID';
684: ELSIF (p_sys_qual ='DELV') THEN
685: x_table_name := 'AMS_DELIVERABLES_VL';
686: x_pk_name := 'DELIVERABLE_ID';
687: ELSIF (p_sys_qual ='AMET') THEN
688: x_table_name := 'AMS_ACT_METRICS_ALL';
689: x_pk_name := 'ACTIVITY_METRIC_ID';

Line 830: FROM ams_deliverables_vl

826: AND s.campaign_id = c.campaign_id;
827:
828: CURSOR c_deliv(p_object_id IN NUMBER) IS
829: SELECT deliverable_name
830: FROM ams_deliverables_vl
831: WHERE deliverable_id = p_object_id;
832:
833: CURSOR c_event_header(p_object_id IN NUMBER) IS
834: SELECT event_header_name

Line 2645: FROM ams_deliverables_vl

2641:
2642: CURSOR Cur_Delv(p_delv_id IN NUMBER)
2643: IS
2644: SELECT deliverable_name
2645: FROM ams_deliverables_vl
2646: WHERE deliverable_id = p_delv_id;
2647:
2648: CURSOR Cur_Camp(p_camp_id IN NUMBER)
2649: IS