898: l_group_id IN NUMBER )
899: IS
900: SELECT min(start_date_active),
901: max(end_date_active)
902: FROM jtf_rs_grp_relations
903: WHERE ( group_id = l_group_id
904: OR related_group_id = l_group_id )
905: AND nvl(delete_flag, 'N') <> 'Y'
906: AND end_date_active is not null;
909: CURSOR c_related_group_dates_sec(
910: l_group_id IN NUMBER )
911: IS
912: SELECT min(start_date_active)
913: FROM jtf_rs_grp_relations
914: WHERE ( group_id = l_group_id
915: OR related_group_id = l_group_id )
916: AND nvl(delete_flag, 'N') <> 'Y'
917: AND end_date_active is null;