APPS.AMW_LOAD_CTRL_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 270: FROM amw_controls_b b, amw_controls_tl tl

266: AND rownum = 1;
267:
268: CURSOR c_control_exists (c_control_name IN VARCHAR2) IS
269: SELECT b.control_id, b.approval_status
270: FROM amw_controls_b b, amw_controls_tl tl
271: WHERE tl.name = c_control_name
272: AND tl.language = USERENV('LANG')
273: AND tl.control_rev_id = b.control_rev_id
274: AND b.latest_revision_flag='Y';

Line 363: ,l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL

359: l_amw_control_name_prefix := fnd_profile.VALUE ('AMW_CONTROL_NAME_PREFIX');
360: ---02.18.2005 npanandi: ends fix for bug 4141121
361:
362: SELECT DECODE (ctrl_rec.control_name,NULL
363: ,l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL
364: ,ctrl_rec.control_name)
365: INTO l_control_name
366: FROM dual;
367: