APPS.FF_DATA_DICT dependencies on HR_S_ROUTE_PARAMETER_VALUES

Line 1923: from hr_s_route_parameter_values

1919: IS
1920: -- To install parameter values for a given user entity
1921:
1922: select *
1923: from hr_s_route_parameter_values
1924: where user_entity_id = ue_id;
1925:
1926: CURSOR db_item (ue_id IN number)
1927: IS

Line 2081: update hr_s_route_parameter_values

2077:
2078: update hr_s_route_parameters
2079: set route_parameter_id = route_parameter_id -50000000;
2080:
2081: update hr_s_route_parameter_values
2082: set route_parameter_id = route_parameter_id -50000000;
2083:
2084: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
2085:

Line 2109: update /*+NO_INDEX*/ hr_s_route_parameter_values

2105:
2106: update /*+NO_INDEX*/ hr_s_database_items
2107: set user_entity_id = user_entity_id -50000000;
2108:
2109: update /*+NO_INDEX*/ hr_s_route_parameter_values
2110: set user_entity_id = user_entity_id -50000000;
2111:
2112: update /*+NO_INDEX*/ hr_s_report_format_items_f
2113: set user_entity_id = user_entity_id -50000000;

Line 2316: update hr_s_route_parameter_values

2312: set route_id = l_new_surrogate_key
2313: , route_parameter_id = l_new_parameter_id
2314: where route_parameter_id = delivered_params.route_parameter_id;
2315:
2316: update hr_s_route_parameter_values
2317: set route_parameter_id = l_new_parameter_id
2318: where route_parameter_id = delivered_params.route_parameter_id;
2319:
2320: END LOOP delivered_params;

Line 2363: update hr_s_route_parameter_values

2359: update hr_s_database_items
2360: set user_entity_id = l_new_entity_id
2361: where user_entity_id = delivered_entities.user_entity_id;
2362:
2363: update hr_s_route_parameter_values
2364: set user_entity_id = l_new_entity_id
2365: where user_entity_id = delivered_entities.user_entity_id;
2366:
2367: update hr_s_report_format_items_f

Line 2389: delete from hr_s_route_parameter_values a

2385: from hr_s_user_entities b
2386: where b.route_id = v_route_id
2387: );
2388:
2389: delete from hr_s_route_parameter_values a
2390: where a.user_entity_id in
2391: (select b.user_entity_id
2392: from hr_s_user_entities b
2393: where b.route_id = v_route_id

Line 2659: from hr_s_route_parameter_values

2655: from ff_database_items
2656: where user_entity_id = v_user_entity_id)
2657: or exists
2658: (select value
2659: from hr_s_route_parameter_values
2660: where user_entity_id = v_user_entity_id
2661: MINUS
2662: select value
2663: from ff_route_parameter_values