APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1158: FROM jtf_rs_group_members mem, jtf_rs_roles_b rol, jtf_rs_role_relations rlt

1154: */
1155: BEGIN
1156: SELECT 'VALID'
1157: INTO l_select
1158: FROM jtf_rs_group_members mem, jtf_rs_roles_b rol, jtf_rs_role_relations rlt
1159: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
1160: AND rlt.delete_flag = 'N'
1161: AND sysdate >= rlt.start_date_active
1162: AND (rlt.end_date_active is null OR

Line 1777: from jtf_rs_group_members grv1

1773: , JTF_RS_GROUPS_DENORM grpd
1774: , jtf_rs_roles_b rol
1775: WHERE grpd.parent_group_id = grv.parent_group_id
1776: and grpd.group_id IN ( select grv1.group_id
1777: from jtf_rs_group_members grv1
1778: where grv1.resource_id = cl_eff_resource_id )
1779: and grv.CURRENT_USER_ID = cl_current_user_id
1780: and grv.group_id = grv.parent_group_id
1781: and grv.role_code = rol.role_code

Line 1911: from jtf_rs_group_members grv1

1907: WHERE ar.resource_id = grv.resource_id
1908: and grpd.parent_group_id = grv.parent_group_id
1909: and exists (
1910: select 1
1911: from jtf_rs_group_members grv1
1912: where grpd.group_id = grv1.group_id
1913: and grv1.resource_id = lp_resource_id )
1914: and grv.CURRENT_USER_ID = l_user_id )
1915: and rownum < 2;