DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_WF dependencies on JTF_RS_TEAM_MEMBERS_VL

Line 733: jtf_rs_team_members_vl tm,

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

Line 756: jtf_rs_team_members_vl tm,

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

Line 779: jtf_rs_team_members_vl tm,

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