APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 851: FROM jtf_rs_group_members jrgm,

847: l_group_id IN NUMBER )
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'

Line 865: FROM jtf_rs_group_members jrgm,

861: CURSOR c_grp_mbr_role_dates_sec(
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'

Line 935: jtf_rs_group_members GM1,

931: IS
932: SELECT 'Y'
933: FROM jtf_rs_groups_vl G1,
934: jtf_rs_groups_vl G2,
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,

Line 936: jtf_rs_group_members GM2,

932: SELECT 'Y'
933: FROM jtf_rs_groups_vl G1,
934: jtf_rs_groups_vl G2,
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