DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_WF dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 734: jtf_rs_resource_extns_vl re,

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
738: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 757: jtf_rs_resource_extns_vl re,

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
761: AND nvl (t.end_date_active, sysdate + 1) >= sysdate

Line 780: jtf_rs_resource_extns_vl re,

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
784: AND nvl (t.end_date_active, sysdate + 1) >= sysdate