[Home] [Help]
58: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
59:
60: CURSOR c_get_group_id ( c_group_name VARCHAR2 ) IS
61: SELECT group_id
62: FROM jtf_rs_groups_vl
63: WHERE upper(group_name) = upper(c_group_name)
64: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
65:
66: CURSOR c_get_role_code ( c_role_name VARCHAR2 ) IS