APPS.OKL_AM_ASSET_RETURN_WF dependencies on JTF_RS_ROLE_RELATIONS_VL

Line 587: jtf_rs_role_relations_vl jtfr,

583: CURSOR wf_users_csr(c_team_id NUMBER)
584: IS
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,

Line 732: jtf_rs_role_relations_vl jtfr,

728: c_name VARCHAR)
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

Line 755: jtf_rs_role_relations_vl jtfr,

751: AND wu.name > nvl(c_name, '0')
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

Line 778: jtf_rs_role_relations_vl jtfr,

774: AND wu.name > nvl(c_name, '0')
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

Line 2411: jtf_rs_role_relations_vl jtfr,

2407: CURSOR wf_users_csr(c_team_id NUMBER)
2408: IS
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,

Line 2569: jtf_rs_role_relations_vl jtfr,

2565: c_name VARCHAR)
2566: IS
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,