APPS.PAY_IP_BAL_UPL_STRUCT dependencies on PAY_BALANCE_DIMENSIONS

Line 189: from pay_balance_dimensions

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

Line 232: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

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