APPS.AMW_LOAD_RC_DATA dependencies on DUAL

Line 840: FROM dual;

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:
842: l_control_rec.name := l_control_name;
843: l_control_rec.description := nvl(rc_rec.CONTROL_DESCRIPTION, l_control_name);
844: l_control_rec.approval_status := l_control_approval_status_code;

Line 1808: FROM dual;

1804:
1805:
1806: CURSOR c_process_objective_id IS
1807: SELECT AMW_process_objectives_S.NEXTVAL
1808: FROM dual;
1809:
1810: l_rowid amw_process_objectives_vl.row_id%type;
1811: l_get_objective c_get_objective%rowtype;
1812: l_process_objective_id number;

Line 1949: FROM dual;

1945: -- AND tag=p_lookup_tag;
1946:
1947: CURSOR c_risk_type_id IS
1948: SELECT AMW_RISK_TYPE_S.NEXTVAL
1949: FROM dual;
1950:
1951: l_risk_type_code VARCHAR2(30);
1952: l_risk_type_code_del VARCHAR2(30);
1953: l_risk_type_flag VARCHAR2(1);