APPS.JTF_TTY_NA_TERRGP dependencies on JTF_RS_ROLES_B

Line 1677: jtf_rs_roles_b rol,

1673: mdv.group_id,
1674: mdv.dir_user_id
1675: FROM jtf_tty_my_resources_v mdv,
1676: jtf_rs_group_members mem,
1677: jtf_rs_roles_b rol,
1678: jtf_rs_role_relations rlt
1679: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
1680: AND NVL(rlt.delete_flag, 'N') <> 'Y'
1681: AND SYSDATE BETWEEN rlt.start_date_active AND NVL(rlt.end_date_active, SYSDATE)

Line 1698: jtf_rs_roles_b rol,

1694: sdv.group_id,
1695: sdv.dir_user_id
1696: FROM jtf_tty_my_resources_v sdv,
1697: jtf_rs_group_members mem,
1698: jtf_rs_roles_b rol,
1699: jtf_rs_role_relations rlt
1700: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
1701: AND NVL(rlt.delete_flag, 'N') <> 'Y'
1702: AND SYSDATE BETWEEN rlt.start_date_active AND NVL(rlt.end_date_active, SYSDATE)

Line 1715: jtf_rs_roles_b rol1,

1711: AND sdv.current_user_id = p_owner_user_id;
1712: /*
1713: and not exists (select mem1.resource_id from
1714: jtf_rs_group_members mem1,
1715: jtf_rs_roles_b rol1,
1716: jtf_rs_role_relations rlt1
1717: where rlt1.role_resource_type = 'RS_GROUP_MEMBER'
1718: and nvl(rlt1.delete_flag, 'N') <> 'Y'
1719: and sysdate between rlt1.start_date_active

Line 2406: jtf_rs_roles_b rol,

2402: CURSOR groups_managed_c
2403: IS
2404: SELECT mem.group_id
2405: FROM jtf_rs_group_members mem,
2406: jtf_rs_roles_b rol,
2407: jtf_rs_role_relations rlt
2408: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
2409: AND NVL(rlt.delete_flag, 'N') <> 'Y'
2410: AND SYSDATE BETWEEN rlt.start_date_active AND NVL(rlt.end_date_active, SYSDATE)