729: IS
730: SELECT wu.name, wu.display_name
731: FROM jtf_rs_teams_vl t,
732: jtf_rs_role_relations_vl jtfr,
733: jtf_rs_team_members_vl tm,
734: jtf_rs_resource_extns_vl re,
735: wf_users WU
736: WHERE t.team_id = c_team_id
737: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
752: UNION
753: SELECT wu.name, wu.display_name
754: FROM jtf_rs_teams_vl t,
755: jtf_rs_role_relations_vl jtfr,
756: jtf_rs_team_members_vl tm,
757: jtf_rs_resource_extns_vl re,
758: wf_users WU
759: WHERE t.team_id = c_team_id
760: AND nvl (t.start_date_active, sysdate - 1) <= sysdate
775: UNION
776: SELECT wu.name, wu.display_name
777: FROM jtf_rs_teams_vl t,
778: jtf_rs_role_relations_vl jtfr,
779: jtf_rs_team_members_vl tm,
780: jtf_rs_resource_extns_vl re,
781: wf_users WU
782: WHERE t.team_id = c_team_id
783: AND nvl (t.start_date_active, sysdate - 1) <= sysdate