APPS.OKL_AM_ASSET_RETURN_WF dependencies on JTF_RS_TEAM_MEMBERS

Line 589: jtf_rs_Team_Members b,

585: SELECT count(*)
586: FROM jtf_rs_teams_vl t,
587: jtf_rs_role_relations_vl jtfr,
588: jtf_rs_Resource_extns a,
589: jtf_rs_Team_Members b,
590: jtf_rs_Groups_b d,
591: jtf_rs_resource_extns re,
592: wf_users wu
593: WHERE t.team_id = c_team_id

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

Line 2413: jtf_rs_Team_Members b,

2409: SELECT count(1)
2410: FROM jtf_rs_teams_b t,
2411: jtf_rs_role_relations_vl jtfr,
2412: jtf_rs_Resource_extns a,
2413: jtf_rs_Team_Members b,
2414: jtf_rs_Groups_b d,
2415: jtf_rs_resource_extns re,
2416: wf_users WU
2417: WHERE

Line 2571: jtf_rs_Team_Members b,

2567: SELECT wu.name, wu.display_name
2568: FROM jtf_rs_teams_vl t,
2569: jtf_rs_role_relations_vl jtfr,
2570: jtf_rs_Resource_extns a,
2571: jtf_rs_Team_Members b,
2572: jtf_rs_Groups_b d,
2573: jtf_rs_resource_extns re,
2574: wf_users WU
2575: WHERE t.team_id = c_team_id