APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 850: FROM jtf_rs_role_relations

846: l_group_id IN NUMBER )
847: IS
848: SELECT min(start_date_active),
849: max(end_date_active)
850: FROM jtf_rs_role_relations
851: WHERE role_resource_type = 'RS_GROUP'
852: AND role_resource_id = l_group_id
853: AND nvl(delete_flag, 'N') <> 'Y'
854: AND end_date_active is not null;

Line 861: FROM jtf_rs_role_relations

857: CURSOR c_related_role_dates_sec(
858: l_group_id IN NUMBER )
859: IS
860: SELECT min(start_date_active)
861: FROM jtf_rs_role_relations
862: WHERE role_resource_type = 'RS_GROUP'
863: AND role_resource_id = l_group_id
864: AND nvl(delete_flag, 'N') <> 'Y'
865: AND end_date_active is null;

Line 874: jtf_rs_role_relations jrrr

870: IS
871: SELECT min(jrrr.start_date_active),
872: max(jrrr.end_date_active)
873: FROM jtf_rs_group_members jrgm,
874: jtf_rs_role_relations jrrr
875: WHERE jrgm.group_member_id = jrrr.role_resource_id
876: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
877: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
878: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 888: jtf_rs_role_relations jrrr

884: l_group_id IN NUMBER )
885: IS
886: SELECT min(jrrr.start_date_active)
887: FROM jtf_rs_group_members jrgm,
888: jtf_rs_role_relations jrrr
889: WHERE jrgm.group_member_id = jrrr.role_resource_id
890: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
891: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
892: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 926: jtf_rs_role_relations jrrr

922: IS
923: SELECT min(jrrr.start_date_active),
924: max(jrrr.end_date_active)
925: FROM jtf_rs_team_members jrtm,
926: jtf_rs_role_relations jrrr
927: WHERE jrtm.team_member_id = jrrr.role_resource_id
928: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
929: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
930: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 941: jtf_rs_role_relations jrrr

937: l_group_id IN NUMBER )
938: IS
939: SELECT min(jrrr.start_date_active)
940: FROM jtf_rs_team_members jrtm,
941: jtf_rs_role_relations jrrr
942: WHERE jrtm.team_member_id = jrrr.role_resource_id
943: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
944: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
945: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 961: jtf_rs_role_relations RR1,

957: jtf_rs_group_members GM1,
958: jtf_rs_group_members GM2,
959: jtf_rs_group_usages GU1,
960: jtf_rs_group_usages GU2,
961: jtf_rs_role_relations RR1,
962: jtf_rs_role_relations RR2
963: WHERE G1.group_id = GM1.group_id
964: AND G2.group_id = GM2.group_id
965: AND nvl(GM1.delete_flag, 'N') <> 'Y'

Line 962: jtf_rs_role_relations RR2

958: jtf_rs_group_members GM2,
959: jtf_rs_group_usages GU1,
960: jtf_rs_group_usages GU2,
961: jtf_rs_role_relations RR1,
962: jtf_rs_role_relations RR2
963: WHERE G1.group_id = GM1.group_id
964: AND G2.group_id = GM2.group_id
965: AND nvl(GM1.delete_flag, 'N') <> 'Y'
966: AND nvl(GM2.delete_flag, 'N') <> 'Y'