APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 828: FROM jtf_rs_role_relations

824: l_group_id IN NUMBER )
825: IS
826: SELECT min(start_date_active),
827: max(end_date_active)
828: FROM jtf_rs_role_relations
829: WHERE role_resource_type = 'RS_GROUP'
830: AND role_resource_id = l_group_id
831: AND nvl(delete_flag, 'N') <> 'Y'
832: AND end_date_active is not null;

Line 839: FROM jtf_rs_role_relations

835: CURSOR c_related_role_dates_sec(
836: l_group_id IN NUMBER )
837: IS
838: SELECT min(start_date_active)
839: FROM jtf_rs_role_relations
840: WHERE role_resource_type = 'RS_GROUP'
841: AND role_resource_id = l_group_id
842: AND nvl(delete_flag, 'N') <> 'Y'
843: AND end_date_active is null;

Line 852: jtf_rs_role_relations jrrr

848: IS
849: SELECT min(jrrr.start_date_active),
850: max(jrrr.end_date_active)
851: FROM jtf_rs_group_members jrgm,
852: jtf_rs_role_relations jrrr
853: WHERE jrgm.group_member_id = jrrr.role_resource_id
854: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
855: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
856: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 866: jtf_rs_role_relations jrrr

862: l_group_id IN NUMBER )
863: IS
864: SELECT min(jrrr.start_date_active)
865: FROM jtf_rs_group_members jrgm,
866: jtf_rs_role_relations jrrr
867: WHERE jrgm.group_member_id = jrrr.role_resource_id
868: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
869: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
870: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 904: jtf_rs_role_relations jrrr

900: IS
901: SELECT min(jrrr.start_date_active),
902: max(jrrr.end_date_active)
903: FROM jtf_rs_team_members jrtm,
904: jtf_rs_role_relations jrrr
905: WHERE jrtm.team_member_id = jrrr.role_resource_id
906: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
907: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
908: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 919: jtf_rs_role_relations jrrr

915: l_group_id IN NUMBER )
916: IS
917: SELECT min(jrrr.start_date_active)
918: FROM jtf_rs_team_members jrtm,
919: jtf_rs_role_relations jrrr
920: WHERE jrtm.team_member_id = jrrr.role_resource_id
921: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
922: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
923: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 939: jtf_rs_role_relations RR1,

935: jtf_rs_group_members GM1,
936: jtf_rs_group_members GM2,
937: jtf_rs_group_usages GU1,
938: jtf_rs_group_usages GU2,
939: jtf_rs_role_relations RR1,
940: jtf_rs_role_relations RR2
941: WHERE G1.group_id = GM1.group_id
942: AND G2.group_id = GM2.group_id
943: AND nvl(GM1.delete_flag, 'N') <> 'Y'

Line 940: jtf_rs_role_relations RR2

936: jtf_rs_group_members GM2,
937: jtf_rs_group_usages GU1,
938: jtf_rs_group_usages GU2,
939: jtf_rs_role_relations RR1,
940: jtf_rs_role_relations RR2
941: WHERE G1.group_id = GM1.group_id
942: AND G2.group_id = GM2.group_id
943: AND nvl(GM1.delete_flag, 'N') <> 'Y'
944: AND nvl(GM2.delete_flag, 'N') <> 'Y'