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 1904: from hr_s_route_context_usages

1900:
1901: CURSOR usage (r_id IN number) -- To install context usages
1902: IS -- for a given route
1903: select distinct *
1904: from hr_s_route_context_usages
1905: where route_id = r_id;
1906:
1907: CURSOR parameter (r_id IN number) -- To install all route parameters
1908: IS -- for a given route

Line 2050: update /*+NO_INDEX*/ hr_s_route_context_usages

2046:
2047: update /*+NO_INDEX*/ hr_s_dimension_routes
2048: set route_id = route_id - 50000000;
2049:
2050: update /*+NO_INDEX*/ hr_s_route_context_usages
2051: set route_id = route_id - 50000000;
2052:
2053: update /*+NO_INDEX*/ hr_s_user_entities
2054: set route_id = route_id - 50000000;

Line 2251: update hr_s_route_context_usages

2247: update hr_s_dimension_routes
2248: set route_id = l_new_surrogate_key
2249: where route_id = stu_rec.c_Surrogate_key;
2250:
2251: update hr_s_route_context_usages
2252: set route_id = l_new_surrogate_key
2253: where route_id = stu_rec.c_Surrogate_key;
2254:
2255:

Line 2399: delete from hr_s_route_context_usages

2395:
2396: delete from hr_s_user_entities
2397: where route_id = v_route_id;
2398:
2399: delete from hr_s_route_context_usages
2400: where route_id = v_route_id;
2401:
2402: delete from hr_s_route_parameters
2403: where route_id = v_route_id;