APPS.PAY_IN_BAL_UPL_STRUCT dependencies on PAY_BALANCE_DIMENSIONS

Line 205: FROM pay_balance_dimensions

201: l_message VARCHAR2(255);
202:
203: CURSOR csr_bal_dim (l_bal_dim_name IN VARCHAR2) IS
204: SELECT balance_dimension_id
205: FROM pay_balance_dimensions
206: WHERE upper(dimension_name) = l_baldim_name
207: AND ((business_group_id = p_busgrp_id)
208: OR( business_group_id IS NULL
209: AND legislation_code = p_leg_code)

Line 301: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

297: i number := 0;
298: l_bg_id per_business_groups.business_group_id%TYPE;
299: l_leg_code per_business_groups.legislation_code%TYPE;
300: l_bt_id pay_balance_types.balance_type_id%TYPE;
301: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
302: l_procedure VARCHAR2(100);
303: l_message VARCHAR2(255);
304:
305: CURSOR csr_bg IS