DBA Data[Home] [Help]

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_Resource_extns a,
734: jtf_rs_Team_Members b,
735: jtf_rs_Groups_b d,
736: jtf_rs_resource_extns re,

Line 2354: jtf_rs_role_relations_vl jtfr,

2350: CURSOR wf_users_csr(c_team_id NUMBER)
2351: IS
2352: SELECT count(1)
2353: FROM jtf_rs_teams_b t,
2354: jtf_rs_role_relations_vl jtfr,
2355: jtf_rs_Resource_extns a,
2356: jtf_rs_Team_Members b,
2357: jtf_rs_Groups_b d,
2358: jtf_rs_resource_extns re,

Line 2512: jtf_rs_role_relations_vl jtfr,

2508: c_name VARCHAR)
2509: IS
2510: SELECT wu.name, wu.display_name
2511: FROM jtf_rs_teams_vl t,
2512: jtf_rs_role_relations_vl jtfr,
2513: jtf_rs_Resource_extns a,
2514: jtf_rs_Team_Members b,
2515: jtf_rs_Groups_b d,
2516: jtf_rs_resource_extns re,