APPS.AMW_LOAD_RC_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 313: FROM amw_risks_b b, amw_risks_tl tl

309: AND rownum = 1;
310:
311: CURSOR c_risk_exists (c_risk_name IN VARCHAR2) IS
312: SELECT b.risk_id, b.approval_status
313: FROM amw_risks_b b, amw_risks_tl tl
314: WHERE tl.name = c_risk_name
315: AND tl.language = USERENV('LANG')
316: AND tl.risk_rev_id = b.risk_rev_id
317: AND b.latest_revision_flag='Y';