APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 880: FROM jtf_rs_grp_relations

876: l_group_id IN NUMBER )
877: IS
878: SELECT min(start_date_active),
879: max(end_date_active)
880: FROM jtf_rs_grp_relations
881: WHERE ( group_id = l_group_id
882: OR related_group_id = l_group_id )
883: AND nvl(delete_flag, 'N') <> 'Y'
884: AND end_date_active is not null;

Line 891: FROM jtf_rs_grp_relations

887: CURSOR c_related_group_dates_sec(
888: l_group_id IN NUMBER )
889: IS
890: SELECT min(start_date_active)
891: FROM jtf_rs_grp_relations
892: WHERE ( group_id = l_group_id
893: OR related_group_id = l_group_id )
894: AND nvl(delete_flag, 'N') <> 'Y'
895: AND end_date_active is null;