APPS.AMS_DM_TARGET_SOURCES_PVT dependencies on AMS_LIST_SRC_TYPES

Line 894: 'ams_list_src_types',

890:
891: --------------------- data_source_id ------------------------
892: IF p_target_source_rec_type_rec.data_source_id <> FND_API.g_miss_num THEN
893: IF AMS_Utility_PVT.check_fk_exists(
894: 'ams_list_src_types',
895: 'LIST_SOURCE_TYPE_ID',
896: p_target_source_rec_type_rec.data_source_id
897: ) = FND_API.g_false
898: THEN

Line 1228: FROM ams_dm_target_sources dts, ams_list_src_types lst1, ams_list_src_types lst2

1224: )
1225: IS
1226: CURSOR c_check_underlying_obj(p_ds_id IN NUMBER, p_target_id IN NUMBER) IS
1227: SELECT 1
1228: FROM ams_dm_target_sources dts, ams_list_src_types lst1, ams_list_src_types lst2
1229: WHERE dts.target_id = p_target_id
1230: AND lst1.list_source_type_id = p_ds_id
1231: AND lst2.list_source_type_id = dts.data_source_id
1232: AND lst2.list_source_type_id <> p_ds_id