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)
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;
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: