873: RETURN VARCHAR2 AS
874: -- get org_id for contract
875: CURSOR get_res_id_cur(l_user_id NUMBER) IS
876: SELECT resource_id
877: FROM jtf_rs_resource_extns
878: WHERE user_id = l_user_id;
879: l_api_version NUMBER;
880: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
881: l_msg_count NUMBER;
1002: -- in user. The resource has to have a role of CONTRACT for this to be
1003: -- considered
1004: CURSOR res_csr IS
1005: SELECT res.resource_id
1006: FROM jtf_rs_resource_extns res,
1007: jtf_rs_role_relations rrr,
1008: jtf_rs_roles_b rr
1009: WHERE res.user_id = Fnd_Global.user_id
1010: AND l_date BETWEEN res.start_date_active