APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 873: FROM jtf_rs_group_members jrgm,

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

Line 887: FROM jtf_rs_group_members jrgm,

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

Line 957: jtf_rs_group_members GM1,

953: IS
954: SELECT 'Y'
955: FROM jtf_rs_groups_vl G1,
956: jtf_rs_groups_vl G2,
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,

Line 958: jtf_rs_group_members GM2,

954: SELECT 'Y'
955: FROM jtf_rs_groups_vl G1,
956: jtf_rs_groups_vl G2,
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