APPS.FF_DATA_DICT dependencies on HR_S_ROUTE_CONTEXT_USAGES

Line 183: update /*+NO_INDEX*/ hr_s_route_context_usages

179:
180: update /*+NO_INDEX*/ hr_s_contexts
181: set context_id = context_id - 50000000;
182:
183: update /*+NO_INDEX*/ hr_s_route_context_usages
184: set context_id = context_id - 50000000;
185:
186: update /*+NO_INDEX*/ hr_s_ftype_context_usages
187: set context_id = context_id - 50000000;

Line 264: update hr_s_route_context_usages

260: update hr_s_ftype_context_usages
261: set context_id = l_new_surrogate_key
262: where context_id = stu_rec.c_surrogate_key;
263:
264: update hr_s_route_context_usages
265: set context_id = l_new_surrogate_key
266: where context_id = stu_rec.c_surrogate_key;
267:
268: update hr_s_function_context_usages

Line 1920: from hr_s_route_context_usages

1916:
1917: CURSOR usage (r_id IN number) -- To install context usages
1918: IS -- for a given route
1919: select distinct *
1920: from hr_s_route_context_usages
1921: where route_id = r_id;
1922:
1923: CURSOR parameter (r_id IN number) -- To install all route parameters
1924: IS -- for a given route

Line 2066: update /*+NO_INDEX*/ hr_s_route_context_usages

2062:
2063: update /*+NO_INDEX*/ hr_s_dimension_routes
2064: set route_id = route_id - 50000000;
2065:
2066: update /*+NO_INDEX*/ hr_s_route_context_usages
2067: set route_id = route_id - 50000000;
2068:
2069: update /*+NO_INDEX*/ hr_s_user_entities
2070: set route_id = route_id - 50000000;

Line 2267: update hr_s_route_context_usages

2263: update hr_s_dimension_routes
2264: set route_id = l_new_surrogate_key
2265: where route_id = stu_rec.c_Surrogate_key;
2266:
2267: update hr_s_route_context_usages
2268: set route_id = l_new_surrogate_key
2269: where route_id = stu_rec.c_Surrogate_key;
2270:
2271:

Line 2425: delete from hr_s_route_context_usages

2421:
2422: delete from hr_s_user_entities
2423: where route_id = v_route_id;
2424:
2425: delete from hr_s_route_context_usages
2426: where route_id = v_route_id;
2427:
2428: delete from hr_s_route_parameters
2429: where route_id = v_route_id;