APPS.PYSGBUPL dependencies on PAY_BALANCE_DIMENSIONS

Line 190: from pay_balance_dimensions

186: BEGIN
187: --
188: select balance_dimension_id
189: into l_balance_dim_id
190: from pay_balance_dimensions
191: where upper(dimension_name) = l_baldim_name
192: and ((business_group_id = p_busgrp_id)
193: or( business_group_id is null
194: and legislation_code = p_leg_code)

Line 231: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

227: i number := 0;
228: l_bg_id per_business_groups.business_group_id%TYPE;
229: l_leg_code per_business_groups.legislation_code%TYPE;
230: l_bt_id pay_balance_types.balance_type_id%TYPE;
231: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
232: --
233: cursor c_each_batch (c_batch_id number) is
234: select balance_name,
235: dimension_name