APPS.AMW_SCOPE_PVT dependencies on AMW_AUDIT_SCOPE_PROCESSES

Line 3736: DELETE FROM amw_audit_scope_processes

3732: DELETE FROM AMW_ORG_CERT_EVAL_SUM
3733: WHERE organization_id = p_object_id
3734: AND certification_id = p_entity_id;
3735: ELSIF p_entity_type = 'PROJECT' THEN
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

Line 3934: DELETE FROM amw_audit_scope_processes

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
3936: AND (organization_id, process_id) NOT IN
3937: (SELECT organization_id, process_id
3938: FROM amw_execution_scope

Line 3943: INSERT INTO amw_audit_scope_processes (

3939: WHERE entity_type = 'PROJECT'
3940: AND entity_id = p_audit_project_id
3941: AND process_id IS NOT NULL);
3942:
3943: INSERT INTO amw_audit_scope_processes (
3944: audit_project_id,
3945: organization_id,
3946: process_id,
3947: process_org_rev_id,

Line 3970: FROM amw_audit_scope_processes

3966: AND entity_id = p_audit_project_id
3967: AND level_id > 3
3968: AND (organization_id, process_id) NOT IN (
3969: SELECT organization_id, process_id
3970: FROM amw_audit_scope_processes
3971: WHERE audit_project_id = p_audit_project_id);
3972:
3973:
3974: END populate_proj_denorm_tables;