DBA Data[Home] [Help]

APPS.WSH_RU_ROLES_PVT dependencies on DUAL

Line 19: SELECT wsh_roles_s.nextval FROM DUAL;

15: CURSOR c_dup_role_name IS
16: SELECT role_id FROM WSH_ROLES WHERE name = p_role_record.name;
17:
18: CURSOR c_new_role_id IS
19: SELECT wsh_roles_s.nextval FROM DUAL;
20:
21: CURSOR c_role_rowid(x_role_id IN NUMBER) IS
22: SELECT rowid FROM WSH_ROLES WHERE role_id = x_role_id;
23: