APPS.OKL_AM_ASSET_RETURN_WF dependencies on JTF_RS_TEAMS_VL

Line 586: FROM jtf_rs_teams_vl t,

582: -- cursor to find valid notification user
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,

Line 731: FROM jtf_rs_teams_vl t,

727: c_current_user NUMBER,
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

Line 754: FROM jtf_rs_teams_vl t,

750: AND ROWNUM < c_current_user
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

Line 777: FROM jtf_rs_teams_vl t,

773: AND ROWNUM < c_current_user
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

Line 2161: JTF_RS_TEAMS_VL T

2157: FROM OKL_PRTFL_CNTRCTS_B PFC,
2158: OKL_PRTFL_LINES_V PFCL,
2159: OKC_K_HEADERS_V AD,
2160: FND_LOOKUPS FND,
2161: JTF_RS_TEAMS_VL T
2162: WHERE PFC.KHR_ID = c_id
2163: AND PFC.ID = PFCL.PFC_ID
2164: AND AD.ID = PFC.KHR_ID
2165: AND ASSET_TRACK_STRATEGY_CODE = FND.LOOKUP_CODE

Line 2568: FROM jtf_rs_teams_vl t,

2564: c_current_user NUMBER,
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,