APPS.PAY_DB_BALANCES_PKG dependencies on PAY_DIMENSION_ROUTES

Line 163: insert into pay_dimension_routes

159: if (not p_route_type in ('RR', 'SRB')) then
160: hr_utility.set_message(801, 'HR_BAD_BALDIM_DATA');
161: hr_utility.raise_error;
162: end if;
163: insert into pay_dimension_routes
164: (balance_dimension_id,
165: route_id,
166: route_type,
167: run_dimension_id,

Line 181: from pay_dimension_routes

177: p_baltyp_col,
178: p_dec_required
179: from sys.dual
180: where not exists (select ''
181: from pay_dimension_routes
182: where balance_dimension_id = p_dim_id
183: and route_type = p_route_type
184: and priority = p_priority);
185: end create_dimension_route;