APPS.AMS_DM_TARGET_VALUE_PVT dependencies on AMS_DM_TARGETS_VL

Line 79: FROM ams_dm_targets_vl

75:
76: -- Cursor to get the data source id for the target
77: CURSOR c_datasource_id (l_tgtId IN NUMBER) IS
78: SELECT data_source_id
79: FROM ams_dm_targets_vl
80: WHERE target_id = l_tgtId;
81:
82:
83: BEGIN

Line 594: FROM ams_dm_targets_vl

590:
591: -- Cursor to get the data source id for the target
592: CURSOR c_datasource_id (l_tgtId IN NUMBER) IS
593: SELECT data_source_id
594: FROM ams_dm_targets_vl
595: WHERE target_id = l_tgtId;
596:
597: -- Cursor to count the active targets defined for a data source
598: CURSOR c_target_count (l_dsId IN NUMBER) IS

Line 600: FROM AMS_DM_TARGETS_VL

596:
597: -- Cursor to count the active targets defined for a data source
598: CURSOR c_target_count (l_dsId IN NUMBER) IS
599: SELECT count(*)
600: FROM AMS_DM_TARGETS_VL
601: WHERE DATA_SOURCE_ID = l_dsId
602: AND ACTIVE_FLAG = 'Y';
603:
604: BEGIN