APPS.AMW_SCOPE_PVT dependencies on AMW_RISKS_B

Line 1741: FROM AMW_RISKS_B risk

1737: FOR scope_rec IN c_project_scope LOOP
1738:
1739: UPDATE AMW_RISK_ASSOCIATIONS ara
1740: SET ara.risk_rev_id = (SELECT risk.risk_rev_id
1741: FROM AMW_RISKS_B risk
1742: WHERE risk.risk_id = ara.risk_id
1743: AND risk.curr_approved_flag = 'Y')
1744: WHERE ara.object_type = 'PROJECT'
1745: AND ara.pk1 = p_audit_project_id

Line 1778: FROM amw_risk_associations ara, amw_risks_b risk

1774: scope_rec.organization_id,
1775: scope_rec.process_id,
1776: 'PROJECT',
1777: 1
1778: FROM amw_risk_associations ara, amw_risks_b risk
1779: WHERE ara.object_type = 'PROCESS_ORG'
1780: AND ara.pk1 = scope_rec.organization_id
1781: AND ara.pk2 = scope_rec.process_id
1782: AND ara.risk_id = risk.risk_id

Line 2082: FROM AMW_RISKS_B risk

2078: FOR scope_org_rec IN c_project_scope_org LOOP
2079:
2080: UPDATE AMW_RISK_ASSOCIATIONS ara
2081: SET ara.risk_rev_id = (SELECT risk.risk_rev_id
2082: FROM AMW_RISKS_B risk
2083: WHERE risk.risk_id = ara.risk_id
2084: AND risk.curr_approved_flag = 'Y')
2085: WHERE ara.object_type = 'PROJECT'
2086: AND ara.pk1 = p_audit_project_id

Line 2119: FROM amw_risk_associations ara, amw_risks_b risk

2115: scope_org_rec.organization_id,
2116: null,
2117: 'PROJECT',
2118: 1
2119: FROM amw_risk_associations ara, amw_risks_b risk
2120: WHERE ara.object_type = 'ENTITY_RISK'
2121: AND ara.pk1 = scope_org_rec.organization_id
2122: AND ara.pk2 IS NULL
2123: AND ara.risk_id = risk.risk_id

Line 2744: FROM amw_risks_b risk

2740: FOR each_rec IN get_records_in_scope
2741: LOOP
2742: UPDATE amw_risk_associations ara
2743: SET ara.risk_rev_id = (SELECT risk.risk_rev_id
2744: FROM amw_risks_b risk
2745: WHERE risk.risk_id = ara.risk_id
2746: AND risk.curr_approved_flag = 'Y')
2747: WHERE ara.object_type = p_entity_type
2748: AND ara.pk1 = p_entity_id

Line 2779: FROM amw_risk_associations ara, amw_risks_b risk

2775: ara.pk1,
2776: ara.pk2,
2777: p_entity_type,
2778: 1
2779: FROM amw_risk_associations ara, amw_risks_b risk
2780: WHERE ara.object_type = 'PROCESS_ORG'
2781: AND ara.pk1 = each_rec.organization_id
2782: AND ara.pk2 = each_rec.process_id
2783: AND ara.risk_id = risk.risk_id

Line 2930: FROM AMW_RISKS_B risk

2926: FOR scope_org_rec IN c_scope_org LOOP
2927:
2928: UPDATE AMW_RISK_ASSOCIATIONS ara
2929: SET ara.risk_rev_id = (SELECT risk.risk_rev_id
2930: FROM AMW_RISKS_B risk
2931: WHERE risk.risk_id = ara.risk_id
2932: AND risk.curr_approved_flag = 'Y')
2933: WHERE ara.object_type = p_entity_type
2934: AND ara.pk1 = p_entity_id

Line 2967: FROM amw_risk_associations ara, amw_risks_b risk

2963: scope_org_rec.organization_id,
2964: null,
2965: p_entity_type,
2966: 1
2967: FROM amw_risk_associations ara, amw_risks_b risk
2968: WHERE ara.object_type = 'ENTITY_RISK'
2969: AND ara.pk1 = scope_org_rec.organization_id
2970: AND ara.pk2 IS NULL
2971: AND ara.risk_id = risk.risk_id