DBA Data[Home] [Help]

APPS.AMW_SCOPE_PVT dependencies on AMW_OPINIONS_V

Line 2253: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_project_id

2249: AND aca2.control_rev_id = control.control_rev_id
2250: )
2251: and aca.control_id in
2252: (select distinct control_id from amw_control_associations where pk1=p_source_project_id and object_type='PROJECT'
2253: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_project_id
2254: and audit_result_code ='EFFECTIVE' and
2255: object_name='AMW_ORG_CONTROL') );
2256: END IF;
2257: