APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_OPINIONS_V

Line 1783: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id

1779: AND ENTITY_ID = p_source_entity_id
1780: AND aes.PROCESS_ID is not null
1781: and exists(
1782: select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1783: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1784: and audit_result_code ='EFFECTIVE' and
1785: object_name='AMW_ORG_CONTROL') and pk3=aes.PROCESS_ID);
1786:
1787:

Line 1833: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id

1829: AND ENTITY_ID = p_source_entity_id
1830: AND aes.PARENT_PROCESS_ID =-1
1831: AND exists(select 1 from AMW_EXECUTION_SCOPE aes2 where
1832: exists (select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1833: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1834: and audit_result_code ='EFFECTIVE' and
1835: object_name='AMW_ORG_CONTROL') and pk3=aes2.PROCESS_ID) and aes.process_id=aes2.parent_process_id );
1836:
1837:

Line 1883: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id

1879: AND ENTITY_ID = p_source_entity_id
1880: AND aes.PROCESS_ID is null
1881: and exists(
1882: select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1883: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1884: and audit_result_code ='EFFECTIVE' and
1885: object_name='AMW_ORG_CONTROL') and pk3 is null);
1886:
1887: