APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_RISKS_B

Line 219: FROM AMW_RISKS_B

215: BEGIN
216: IF (p_risk_id IS NOT NULL) THEN
217: SELECT risk_rev_id
218: BULK COLLECT INTO l_risk_rev_id_list
219: FROM AMW_RISKS_B
220: WHERE risk_id = p_risk_id;
221:
222: -- Risk Type Association
223: FORALL i IN l_risk_rev_id_list.FIRST .. l_risk_rev_id_list.LAST

Line 244: DELETE FROM AMW_RISKS_B WHERE risk_id = p_risk_id;

240: -- Risk
241: FORALL i IN l_risk_rev_id_list.FIRST .. l_risk_rev_id_list.LAST
242: DELETE FROM AMW_RISKS_TL WHERE risk_rev_id = l_risk_rev_id_list(i);
243:
244: DELETE FROM AMW_RISKS_B WHERE risk_id = p_risk_id;
245:
246: FND_FILE.put_line(fnd_file.log, 'Delete Risk : risk_id = '||p_risk_id);
247:
248: IF (sql%notfound) then