APPS.JTF_TTY_NA_TERRGP dependencies on JTF_RS_ROLE_RELATIONS

Line 700: jtf_rs_role_relations rlt ,

696: BEGIN
697: SELECT 'Y' INTO result
698: FROM jtf_tty_named_acct_rsc narsc,
699: jtf_tty_terr_grp_accts tga,
700: jtf_rs_role_relations rlt ,
701: jtf_rs_group_members grpmem ,
702: jtf_rs_groups_denorm grpdn
703: WHERE narsc.terr_group_account_id = tga.terr_group_account_id
704: AND tga.terr_group_id = DelCandidateGrp(idx)

Line 864: jtf_rs_role_relations rlt ,

860: DELETE FROM jtf_tty_named_acct_rsc narsc
861: WHERE narsc.terr_group_account_id
862: IN ( SELECT terr_group_account_id
863: FROM jtf_tty_terr_grp_accts,
864: jtf_rs_role_relations rlt ,
865: jtf_rs_group_members grpmem ,
866: jtf_rs_groups_denorm grpdn
867: WHERE terr_group_id = p_terr_gp_id
868: AND grpmem.resource_id = narsc.resource_id

Line 1678: jtf_rs_role_relations rlt

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)
1682: AND rlt.role_id = rol.role_id

Line 1699: jtf_rs_role_relations rlt

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)
1703: AND rlt.role_id = rol.role_id

Line 1716: jtf_rs_role_relations rlt1

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
1720: and nvl(rlt1.end_date_active, sysdate)

Line 2407: jtf_rs_role_relations rlt

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)
2411: AND rlt.role_id = rol.role_id