APPS.AMW_LOAD_RCM_ORG_DATA dependencies on AMW_CONTROLS_TL

Line 11: /* Insert into AMW_CONTROLS_B and AMW_CONTROLS_TL */

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 */
15: /* Insert into AMW_CONTROL_ASSERTIONS */

Line 337: FROM amw_controls_b b, amw_controls_tl tl

333: AND b.latest_revision_flag='Y';
334:
335: CURSOR c_control_exists (c_control_name IN VARCHAR2) IS
336: SELECT b.control_id, b.approval_status
337: FROM amw_controls_b b, amw_controls_tl tl
338: WHERE tl.name = c_control_name
339: AND tl.language = USERENV('LANG')
340: AND tl.control_rev_id = b.control_rev_id
341: AND b.latest_revision_flag='Y';

Line 854: l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL,

850: l_revise_control_flag = 'Y') THEN
851:
852: SELECT DECODE (rc_rec.control_name,
853: NULL,
854: l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL,
855: rc_rec.control_name)
856: INTO l_control_name
857: FROM dual;
858: