APPS.OKS_EXTWAR_UTIL_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 267: FROM jtf_rs_resource_extns jrd,

263: l_user_id fnd_user.user_id%TYPE;
264:
265: CURSOR resource_details(p_resource_id number) IS
266: SELECT fu.user_id
267: FROM jtf_rs_resource_extns jrd,
268: fnd_user fu
269: WHERE jrd.resource_id=p_resource_id
270: AND fu.user_id = jrd.user_id;
271:

Line 410: select resource_name from jtf_rs_resource_extns_tl

406:
407:
408: FUNCTION GET_RESOURCE_NAME (p_resource_id Number) RETURN VARCHAR2 IS
409: CURSOR resource_name IS
410: select resource_name from jtf_rs_resource_extns_tl
411: where resource_id = p_resource_id
412: and language = userenv('LANG');
413:
414: l_resource_name VARCHAR2(200);

Line 1735: FROM jtf_rs_resource_extns jrd,fnd_user fu

1731: ---------------------------------------------------------------------
1732:
1733: CURSOR resource_details(p_resource_id number) IS
1734: SELECT fu.user_id
1735: FROM jtf_rs_resource_extns jrd,fnd_user fu
1736: WHERE jrd.resource_id=p_resource_id
1737: AND fu.user_id = jrd.user_id;
1738:
1739: CURSOR create_contact_resource IS