DBA Data[Home] [Help]

APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 132: FROM jtf_rs_rep_managers mgr, jtf_rs_resource_extns res

128: , l_sysdate, l_user_id
129: FROM (
130: SELECT /*+ use_hash(res mgr) parallel(res) parallel(mgr) */
131: DISTINCT mgr.resource_id, res.user_id, mgr.group_id
132: FROM jtf_rs_rep_managers mgr, jtf_rs_resource_extns res
133: WHERE mgr.hierarchy_type IN ('MGR_TO_MGR','ADMIN_TO_ADMIN')
134: AND mgr.resource_id = mgr.parent_resource_id
135: AND l_bis_date BETWEEN mgr.start_date_active
136: AND NVL(mgr.end_date_active,to_date('12/31/4712','MM/DD/RRRR'))

Line 175: FROM jtf_rs_rep_managers mgr, jtf_rs_resource_extns res

171: , 'Y' active_grp_rel_only
172: FROM (
173: SELECT /*+ use_hash(res mgr) parallel(res) parallel(mgr) */
174: DISTINCT mgr.resource_id, res.user_id, mgr.group_id
175: FROM jtf_rs_rep_managers mgr, jtf_rs_resource_extns res
176: WHERE mgr.hierarchy_type IN ('MGR_TO_MGR','ADMIN_TO_ADMIN')
177: AND mgr.resource_id = mgr.parent_resource_id
178: AND l_bis_date BETWEEN mgr.start_date_active
179: AND NVL(mgr.end_date_active,to_date('12/31/4712','MM/DD/RRRR'))