[Home] [Help]
29: CURSOR get_resource_name (
30: c_user_id NUMBER
31: ) IS
32: SELECT source_name
33: FROM jtf_rs_resource_extns
34: WHERE user_id = c_user_id
35: AND SYSDATE BETWEEN start_date_active
36: AND NVL (
37: end_date_active,