APPS.AMW_SCOPE_PVT dependencies on AMW_CONTROLS_B

Line 1798: FROM AMW_CONTROLS_B control

1794: );
1795:
1796: UPDATE AMW_CONTROL_ASSOCIATIONS aca
1797: SET aca.control_rev_id = (SELECT control_rev_id
1798: FROM AMW_CONTROLS_B control
1799: WHERE control.control_id = aca.control_id
1800: AND control.curr_approved_flag = 'Y')
1801: WHERE aca.object_type = 'PROJECT'
1802: AND aca.pk1 = p_audit_project_id

Line 1837: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control

1833: scope_rec.process_id,
1834: ara.risk_id,
1835: 'PROJECT',
1836: 1
1837: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control
1838: WHERE aca.object_type = 'RISK_ORG'
1839: AND aca.pk1 = scope_rec.organization_id
1840: AND aca.pk2 = scope_rec.process_id
1841: AND aca.pk3 = ara.risk_id

Line 2137: FROM AMW_CONTROLS_B control

2133: );
2134:
2135: UPDATE AMW_CONTROL_ASSOCIATIONS aca
2136: SET aca.control_rev_id = (SELECT control_rev_id
2137: FROM AMW_CONTROLS_B control
2138: WHERE control.control_id = aca.control_id
2139: AND control.curr_approved_flag = 'Y')
2140: WHERE aca.object_type = 'PROJECT'
2141: AND aca.pk1 = p_audit_project_id

Line 2177: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control

2173: null,
2174: ara.risk_id,
2175: 'PROJECT',
2176: 1
2177: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control
2178: WHERE aca.object_type = 'ENTITY_CONTROL'
2179: AND aca.pk1 = scope_org_rec.organization_id
2180: AND aca.pk2 = ara.risk_id
2181: AND aca.pk3 IS NULL

Line 2230: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control

2226: null,
2227: ara.risk_id,
2228: 'PROJECT',
2229: 1
2230: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control
2231: WHERE aca.object_type = 'ENTITY_CONTROL'
2232: AND aca.pk1 = scope_org_rec.organization_id
2233: AND aca.pk2 = ara.risk_id
2234: AND aca.pk3 IS NULL

Line 2800: FROM amw_controls_b control

2796:
2797:
2798: UPDATE amw_control_associations aca
2799: SET aca.control_rev_id = (SELECT control_rev_id
2800: FROM amw_controls_b control
2801: WHERE control.control_id = aca.control_id
2802: AND control.curr_approved_flag = 'Y')
2803: WHERE aca.object_type = p_entity_type
2804: AND aca.pk1 = p_entity_id

Line 2837: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control

2833: each_rec.process_id,
2834: ara.risk_id,
2835: p_entity_type,
2836: 1
2837: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control
2838: WHERE aca.object_type = 'RISK_ORG'
2839: AND aca.pk1 = each_rec.organization_id
2840: AND aca.pk2 = each_rec.process_id
2841: AND aca.pk3 = ara.risk_id

Line 2986: FROM AMW_CONTROLS_B control

2982:
2983: UPDATE AMW_CONTROL_ASSOCIATIONS aca
2984: SET aca.control_rev_id =
2985: (SELECT control_rev_id
2986: FROM AMW_CONTROLS_B control
2987: WHERE control.control_id = aca.control_id
2988: AND control.curr_approved_flag = 'Y')
2989: WHERE aca.object_type = p_entity_type
2990: AND aca.pk1 = p_entity_id

Line 3025: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control

3021: null,
3022: ara.risk_id,
3023: p_entity_type,
3024: 1
3025: FROM amw_control_associations aca,amw_risk_associations ara,amw_controls_b control
3026: WHERE aca.object_type = 'ENTITY_CONTROL'
3027: AND aca.pk1 = scope_org_rec.organization_id
3028: AND aca.pk2 = ara.risk_id
3029: AND aca.pk3 IS NULL