DBA Data[Home] [Help]

APPS.FF_DATA_DICT dependencies on HR_S_BALANCE_DIMENSIONS

Line 2044: update /*+NO_INDEX*/ hr_s_balance_dimensions

2040: update hr_s_application_ownerships
2041: set key_value = key_value - 50000000
2042: where key_name = 'ROUTE_ID';
2043:
2044: update /*+NO_INDEX*/ hr_s_balance_dimensions
2045: set route_id = route_id - 50000000;
2046:
2047: update /*+NO_INDEX*/ hr_s_dimension_routes
2048: set route_id = route_id - 50000000;

Line 2243: update hr_s_balance_dimensions

2239: set key_value = to_char(l_new_surrogate_key)
2240: where key_value = to_char(stu_rec.c_surrogate_key)
2241: and key_name = 'ROUTE_ID';
2242:
2243: update hr_s_balance_dimensions
2244: set route_id = l_new_surrogate_key
2245: where route_id = stu_rec.c_Surrogate_key;
2246:
2247: update hr_s_dimension_routes