APPS.AMW_LOAD_RCM_ORG_DATA dependencies on AMW_RISKS_TL

Line 10: /* Insert into AMW_RISKS_B and AMW_RISKS_TL */

6: /* Major Functionality of the followIng procedure includes: */
7: /* Reads the amw_risk-ctrl_interface table */
8: /* following tables: */
9: /* INSERTS OR UPDATES ARE DONE AGAINIST THE FOLLOWING TABLES */
10: /* Insert into AMW_RISKS_B and AMW_RISKS_TL */
11: /* Insert into AMW_CONTROLS_B and AMW_CONTROLS_TL */
12: /* Insert into AMW_CONTROL_ASSOCIATIONS */
13: /* Insert into AMW_RISK_ASSOCIATIONS */
14: /* Insert into AMW_CONTROL_OBJECTIVES */

Line 329: FROM amw_risks_b b, amw_risks_tl tl

325: AND rownum = 1;
326:
327: CURSOR c_risk_exists (c_risk_name IN VARCHAR2) IS
328: SELECT b.risk_id, b.approval_status
329: FROM amw_risks_b b, amw_risks_tl tl
330: WHERE tl.name = c_risk_name
331: AND tl.language = USERENV('LANG')
332: AND tl.risk_rev_id = b.risk_rev_id
333: AND b.latest_revision_flag='Y';