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: ;
1640: End Handle_Data_Source_Enabling;
1641:
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;
1687: