APPS.AMS_DM_TARGET_VALUE_PVT dependencies on AMS_DM_TARGET_VALUES_VL

Line 73: FROM AMS_DM_TARGET_VALUES_VL

69: FROM dual;
70:
71: CURSOR c_id_exists (l_id IN NUMBER) IS
72: SELECT 1
73: FROM AMS_DM_TARGET_VALUES_VL
74: WHERE TARGET_VALUE_ID = l_id;
75:
76: -- Cursor to get the data source id for the target
77: CURSOR c_datasource_id (l_tgtId IN NUMBER) IS

Line 299: FROM AMS_DM_TARGET_VALUES_VL

295:
296:
297: CURSOR c_get_dm_target_value(p_target_value_id NUMBER) IS
298: SELECT *
299: FROM AMS_DM_TARGET_VALUES_VL
300: WHERE target_value_id = p_target_value_id;
301:
302:
303: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Dm_Target_Value';

Line 582: FROM ams_dm_target_values_vl

578:
579: -- Cursor to get the target id for the target value
580: CURSOR c_target_id (l_tgtValueId IN NUMBER) IS
581: SELECT target_id
582: FROM ams_dm_target_values_vl
583: WHERE target_value_id = l_tgtValueId;
584:
585: -- Cursor to count the target values for a target
586: CURSOR c_target_values_count (l_tgtId IN NUMBER) IS

Line 588: FROM AMS_DM_TARGET_VALUES_VL

584:
585: -- Cursor to count the target values for a target
586: CURSOR c_target_values_count (l_tgtId IN NUMBER) IS
587: SELECT count(*)
588: FROM AMS_DM_TARGET_VALUES_VL
589: WHERE TARGET_ID = l_tgtId;
590:
591: -- Cursor to get the data source id for the target
592: CURSOR c_datasource_id (l_tgtId IN NUMBER) IS

Line 1158: FROM ams_dm_target_values_vl

1154: l_return_status VARCHAR2(1);
1155:
1156: CURSOR c_complete IS
1157: SELECT *
1158: FROM ams_dm_target_values_vl
1159: WHERE target_value_id = p_dm_target_value_rec.target_value_id;
1160: l_dm_target_value_rec c_complete%ROWTYPE;
1161: BEGIN
1162: