APPS.AMS_DM_TARGET_SOURCES_PVT dependencies on AMS_DM_TARGETS_B

Line 544: IS SELECT 1 FROM AMS_DM_TARGETS_B t, AMS_DM_TARGET_SOURCES s

540: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
541: l_object_version_number NUMBER;
542:
543: CURSOR c_target_source (p_target_source_id IN NUMBER)
544: IS SELECT 1 FROM AMS_DM_TARGETS_B t, AMS_DM_TARGET_SOURCES s
545: WHERE s.target_source_id = p_target_source_id
546: AND s.target_id = t.target_id
547: AND s.data_source_id = t.target_source_id;
548:

Line 907: 'ams_dm_targets_b',

903:
904: --------------------- target_id ------------------------
905: IF p_target_source_rec_type_rec.target_id <> FND_API.g_miss_num THEN
906: IF AMS_Utility_PVT.check_fk_exists(
907: 'ams_dm_targets_b',
908: 'target_id',
909: p_target_source_rec_type_rec.target_id
910: ) = FND_API.g_false
911: THEN