APPS.PAYBALUP dependencies on PAY_BALANCE_DIMENSIONS

Line 241: from pay_balance_dimensions

237: BEGIN
238: --
239: select balance_dimension_id
240: into l_balance_dim_id
241: from pay_balance_dimensions
242: where upper(dimension_name) = l_baldim_name
243: and ((business_group_id = p_busgrp_id)
244: or( business_group_id is null
245: and legislation_code = p_leg_code)

Line 282: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

278: i number := 0;
279: l_bg_id per_business_groups.business_group_id%TYPE;
280: l_leg_code per_business_groups.legislation_code%TYPE;
281: l_bt_id pay_balance_types.balance_type_id%TYPE;
282: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
283: --
284: cursor c_each_batch (c_batch_id number) is
285: select balance_name,
286: dimension_name