APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PAY_BALANCE_DIMENSIONS

Line 262: l_baldim_name pay_balance_dimensions.dimension_name%TYPE;

258: ,p_busgrp_id NUMBER
259: ,p_leg_code VARCHAR2
260: ,retcode OUT NOCOPY NUMBER)
261: IS
262: l_baldim_name pay_balance_dimensions.dimension_name%TYPE;
263: l_count NUMBER;
264: l_found BOOLEAN;
265: l_balance_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
266:

Line 265: l_balance_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

261: IS
262: l_baldim_name pay_balance_dimensions.dimension_name%TYPE;
263: l_count NUMBER;
264: l_found BOOLEAN;
265: l_balance_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
266:
267: CURSOR csr_bal_dim (l_bal_dim_name IN VARCHAR2) IS
268: SELECT balance_dimension_id
269: FROM pay_balance_dimensions

Line 269: FROM pay_balance_dimensions

265: l_balance_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
266:
267: CURSOR csr_bal_dim (l_bal_dim_name IN VARCHAR2) IS
268: SELECT balance_dimension_id
269: FROM pay_balance_dimensions
270: WHERE upper(dimension_name) = l_baldim_name
271: AND ( (business_group_id = p_busgrp_id)
272: OR (business_group_id IS null AND legislation_code = p_leg_code)
273: OR (business_group_id IS null AND legislation_code IS null)

Line 368: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;

364: i NUMBER := 0;
365: l_bg_id per_business_groups.business_group_id%TYPE;
366: l_leg_code per_business_groups.legislation_code%TYPE;
367: l_bt_id pay_balance_types.balance_type_id%TYPE;
368: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
369: --
370: CURSOR csr_bg IS
371: SELECT hou.business_group_id,
372: hou.legislation_code