DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 493: ,jtf_rs_resource_extns e

489: NULL
490: FROM
491: jtf_rs_groups_denorm d
492: ,jtf_rs_group_members m
493: ,jtf_rs_resource_extns e
494: ,fnd_grants g
495: ,fnd_objects o
496: WHERE d.parent_group_id = g.parameter2
497: AND TRUNC(SYSDATE)

Line 534: FROM jtf_rs_resource_extns

530:
531: -- Cursor to get current user's JTF resource id
532: CURSOR cur_user_jtf_resource_csr IS
533: SELECT resource_id
534: FROM jtf_rs_resource_extns
535: WHERE user_id = FND_GLOBAL.user_id();
536:
537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
538: l_grantee_key FND_GRANTS.grantee_key%TYPE;

Line 537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;

533: SELECT resource_id
534: FROM jtf_rs_resource_extns
535: WHERE user_id = FND_GLOBAL.user_id();
536:
537: l_resource_id JTF_RS_RESOURCE_EXTNS.resource_id%TYPE;
538: l_grantee_key FND_GRANTS.grantee_key%TYPE;
539: l_grantee_orig_system FND_GRANTS.grantee_orig_system%TYPE;
540: l_grantee_orig_system_id FND_GRANTS.grantee_orig_system_id%TYPE;
541: