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

317: AND b.latest_revision_flag='Y';
318:
319: CURSOR c_control_exists (c_control_name IN VARCHAR2) IS
320: SELECT b.control_id, b.approval_status
321: FROM amw_controls_b b, amw_controls_tl tl
322: WHERE tl.name = c_control_name
323: AND tl.language = USERENV('LANG')
324: AND tl.control_rev_id = b.control_rev_id
325: AND b.latest_revision_flag='Y';

Line 837: ,l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL

833: (lx_control_id is null OR
834: l_revise_control_flag = 'Y') THEN
835:
836: SELECT DECODE (rc_rec.control_name,NULL
837: ,l_amw_control_name_prefix||amw_controls_tl_s1.NEXTVAL
838: ,rc_rec.control_name)
839: INTO l_control_name
840: FROM dual;
841: