DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 473: ,jtf_rs_resource_extns e

469: NULL
470: FROM
471: jtf_rs_groups_denorm d
472: ,jtf_rs_group_members m
473: ,jtf_rs_resource_extns e
474: ,fnd_grants g
475: ,fnd_objects o
476: WHERE d.parent_group_id = g.parameter2
477: AND TRUNC(SYSDATE)

Line 514: FROM jtf_rs_resource_extns

510:
511: -- Cursor to get current user's JTF resource id
512: CURSOR cur_user_jtf_resource_csr IS
513: SELECT resource_id
514: FROM jtf_rs_resource_extns
515: WHERE user_id = FND_GLOBAL.user_id();
516:
517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
518: l_grantee_key FND_GRANTS.grantee_key%TYPE;

Line 517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;

513: SELECT resource_id
514: FROM jtf_rs_resource_extns
515: WHERE user_id = FND_GLOBAL.user_id();
516:
517: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
518: l_grantee_key FND_GRANTS.grantee_key%TYPE;
519: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
520: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
521: