DBA Data[Home] [Help]

APPS.AMW_LOAD_CTRL_DATA dependencies on DUAL

Line 366: FROM dual;

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:
368: OPEN c_control_exists(l_control_name);
369: FETCH c_control_exists INTO lx_control_id, v_control_db_approval_status;
370: CLOSE c_control_exists;