APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 839: FROM jtf_rs_resource_extns

835: RETURN VARCHAR2 AS
836: -- get org_id for contract
837: CURSOR get_res_id_cur(l_user_id NUMBER) IS
838: SELECT resource_id
839: FROM jtf_rs_resource_extns
840: WHERE user_id = l_user_id;
841: l_api_version NUMBER;
842: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
843: l_msg_count NUMBER;

Line 968: FROM jtf_rs_resource_extns res,

964: -- in user. The resource has to have a role of CONTRACT for this to be
965: -- considered
966: CURSOR res_csr IS
967: SELECT res.resource_id
968: FROM jtf_rs_resource_extns res,
969: jtf_rs_role_relations rrr,
970: jtf_rs_roles_b rr
971: WHERE res.user_id = Fnd_Global.user_id
972: AND l_date BETWEEN res.start_date_active