APPS.AMS_DM_TARGET_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 1635: AND (EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')

1631: a.last_updated_by = FND_GLOBAL.user_id
1632: WHERE (a.data_source_id = p_data_source_id OR a.target_source_id = p_data_source_id)
1633: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')
1634: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')
1635: AND (EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')
1636: OR a.data_source_id = a.target_source_id)
1637: AND EXISTS (SELECT 1 FROM ams_dm_target_values_b e where e.target_id = a.target_id)
1638: AND a.active_flag = 'N'
1639: ;

Line 1682: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')

1678: a.last_updated_by = FND_GLOBAL.user_id
1679: WHERE (a.data_source_id = p_master_source_id AND a.target_source_id = p_sub_source_id)
1680: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')
1681: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')
1682: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')
1683: AND EXISTS (SELECT 1 FROM ams_dm_target_values_b e where e.target_id = a.target_id)
1684: AND a.active_flag = 'N'
1685: ;
1686: End Handle_DS_Assoc_Enabling;