[Home] [Help]
1036: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
1037:
1038: CURSOR c_get_group_id ( c_group_name VARCHAR2 ) IS
1039: SELECT group_id
1040: FROM jtf_rs_groups_vl
1041: WHERE upper(group_name) = upper(c_group_name)
1042: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
1043:
1044: CURSOR c_get_role_code ( c_role_name VARCHAR2 ) IS