APPS.AMW_LOAD_RCM_ORG_DATA dependencies on DUAL

Line 857: FROM dual;

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

Line 1033: /* have been defined for each association individually e.g. */

1029: /********************************************************************/
1030: /* 03.02.2005 npanandi: check here to see if this Process has */
1031: /* AMW_UPD_ORG_PROC */
1032: /* As compared to Risk Library, where access privileges have */
1033: /* have been defined for each association individually e.g. */
1034: /* Process - Risk - Ctrl assoc, Process - Risk assoc, */
1035: /* Process - Obj assoc, Ctrl - Ap assoc et.al., in the Organization */
1036: /* context, it is seen that only one check for AMW_UPD_ORG_PROC */
1037: /* privilege is done, and all further associations are based */

Line 1928: FROM dual;

1924:
1925:
1926: CURSOR c_process_objective_id IS
1927: SELECT AMW_process_objectives_S.NEXTVAL
1928: FROM dual;
1929:
1930: l_rowid amw_process_objectives_vl.row_id%type;
1931: l_get_objective c_get_objective%rowtype;
1932: l_process_objective_id number;

Line 2067: FROM dual;

2063: AND tag=p_lookup_tag;
2064:
2065: CURSOR c_risk_type_id IS
2066: SELECT AMW_RISK_TYPE_S.NEXTVAL
2067: FROM dual;
2068:
2069: l_risk_type_code VARCHAR2(30);
2070: l_risk_type_code_del VARCHAR2(30);
2071: l_risk_type_flag VARCHAR2(1);