APPS.FF_DATA_DICT dependencies on HR_S_ROUTE_PARAMETER_VALUES

Line 1939: from hr_s_route_parameter_values

1935: IS
1936: -- To install parameter values for a given user entity
1937:
1938: select *
1939: from hr_s_route_parameter_values
1940: where user_entity_id = ue_id;
1941:
1942: CURSOR db_item (ue_id IN number)
1943: IS

Line 2097: update hr_s_route_parameter_values

2093:
2094: update hr_s_route_parameters
2095: set route_parameter_id = route_parameter_id -50000000;
2096:
2097: update hr_s_route_parameter_values
2098: set route_parameter_id = route_parameter_id -50000000;
2099:
2100: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
2101:

Line 2125: update /*+NO_INDEX*/ hr_s_route_parameter_values

2121:
2122: update /*+NO_INDEX*/ hr_s_database_items
2123: set user_entity_id = user_entity_id -50000000;
2124:
2125: update /*+NO_INDEX*/ hr_s_route_parameter_values
2126: set user_entity_id = user_entity_id -50000000;
2127:
2128: update /*+NO_INDEX*/ hr_s_report_format_items_f
2129: set user_entity_id = user_entity_id -50000000;

Line 2332: update hr_s_route_parameter_values

2328: set route_id = l_new_surrogate_key
2329: , route_parameter_id = l_new_parameter_id
2330: where route_parameter_id = delivered_params.route_parameter_id;
2331:
2332: update hr_s_route_parameter_values
2333: set route_parameter_id = l_new_parameter_id
2334: where route_parameter_id = delivered_params.route_parameter_id;
2335:
2336: END LOOP delivered_params;

Line 2389: update hr_s_route_parameter_values

2385: update hr_s_database_items
2386: set user_entity_id = l_new_entity_id
2387: where user_entity_id = delivered_entities.user_entity_id;
2388:
2389: update hr_s_route_parameter_values
2390: set user_entity_id = l_new_entity_id
2391: where user_entity_id = delivered_entities.user_entity_id;
2392:
2393: update hr_s_report_format_items_f

Line 2415: delete from hr_s_route_parameter_values a

2411: from hr_s_user_entities b
2412: where b.route_id = v_route_id
2413: );
2414:
2415: delete from hr_s_route_parameter_values a
2416: where a.user_entity_id in
2417: (select b.user_entity_id
2418: from hr_s_user_entities b
2419: where b.route_id = v_route_id

Line 2700: from hr_s_route_parameter_values

2696: from ff_database_items
2697: where user_entity_id = v_user_entity_id)
2698: or exists
2699: (select value
2700: from hr_s_route_parameter_values
2701: where user_entity_id = v_user_entity_id
2702: MINUS
2703: select value
2704: from ff_route_parameter_values