APPS.AMW_SCOPE_PVT dependencies on AMW_AUDIT_SCOPE_ORGANIZATIONS

Line 3740: DELETE FROM amw_audit_scope_organizations

3736: DELETE FROM amw_audit_scope_processes
3737: WHERE organization_id = p_object_id
3738: AND audit_project_id = p_entity_id;
3739:
3740: DELETE FROM amw_audit_scope_organizations
3741: WHERE organization_id = p_object_id
3742: AND audit_project_id = p_entity_id;
3743: END IF;
3744:

Line 3890: DELETE FROM amw_audit_scope_organizations

3886: PROCEDURE populate_proj_denorm_tables (
3887: p_audit_project_id IN NUMBER
3888: ) IS
3889: BEGIN
3890: DELETE FROM amw_audit_scope_organizations
3891: WHERE audit_project_id = p_audit_project_id
3892: AND organization_id NOT IN
3893: (SELECT organization_id
3894: FROM amw_execution_scope

Line 3899: INSERT INTO amw_audit_scope_organizations (

3895: WHERE entity_type = 'PROJECT'
3896: AND entity_id = p_audit_project_id
3897: AND level_id = 3);
3898:
3899: INSERT INTO amw_audit_scope_organizations (
3900: audit_project_id,
3901: subsidiary_vs,
3902: subsidiary_code,
3903: lob_vs,

Line 3931: FROM amw_audit_scope_organizations

3927: AND es.entity_id = p_audit_project_id
3928: AND es.level_id = 3
3929: AND es.organization_id NOT IN (
3930: SELECT organization_id
3931: FROM amw_audit_scope_organizations
3932: WHERE audit_project_id = p_audit_project_id);
3933:
3934: DELETE FROM amw_audit_scope_processes
3935: WHERE audit_project_id = p_audit_project_id