APPS.HR_USER_INIT_DEDN dependencies on PAY_BALANCE_TYPES

Line 3709: pay_balance_types bt

3705:
3706: SELECT count(0)
3707: INTO already_exists
3708: FROM pay_defined_balances db,
3709: pay_balance_types bt
3710: WHERE db.balance_type_id = bt.balance_type_id
3711: AND bt.balance_name = p_bal_name
3712: AND db.balance_dimension_id = dim_id
3713: AND bt.business_group_id = v_business_group_id;

Line 3776: /* Call pay_balance_types_pkg.chk_balance_type twice in order to check that

3772: -- Create associated balances for deductions.
3773: --
3774: -- "Primary" Balance:
3775: --
3776: /* Call pay_balance_types_pkg.chk_balance_type twice in order to check that
3777: the "Primary Balance" is ok to generate:
3778: procedure chk_balance_type
3779: (
3780: p_row_id varchar2,

Line 3792: pay_balance_types_pkg.chk_balance_type(

3788:
3789: hr_utility.set_location('pyusuidt',217);
3790: -- Check element name, ie. primary balance name, is unique to
3791: -- balances within this BG.
3792: pay_balance_types_pkg.chk_balance_type(
3793: p_row_id => NULL,
3794: p_business_group_id => p_bg_id,
3795: p_legislation_code => NULL,
3796: p_balance_name => p_ele_name,

Line 3803: pay_balance_types_pkg.chk_balance_type(

3799:
3800: hr_utility.set_location('pyusuidt',317);
3801: -- Check element name, ie. primary balance name, is unique to
3802: -- balances provided as startup data.
3803: pay_balance_types_pkg.chk_balance_type(
3804: p_row_id => NULL,
3805: p_business_group_id => NULL,
3806: p_legislation_code => 'US',
3807: p_balance_name => p_ele_name,

Line 5041: v_refund_bal_id pay_balance_types.balance_type_id%TYPE;

5037: v_at_to_bond_id number;
5038:
5039: v_spr_id number(9);
5040: v_assoc_ele_priority number(9);
5041: v_refund_bal_id pay_balance_types.balance_type_id%TYPE;
5042: v_refund_ele_id pay_element_types_f.element_type_id%TYPE;
5043:
5044: CURSOR get_freqrule IS
5045: SELECT ele_payroll_freq_rule_id

Line 5106: from pay_balance_types

5102:
5103: Begin
5104: select balance_type_id
5105: into v_not_taken_baltype_id
5106: from pay_balance_types
5107: where balance_name like p_ele_name||' Not Taken'
5108: and business_group_id + 0 = p_business_group_id ;
5109:
5110: exception when NO_DATA_FOUND then null;

Line 5125: from pay_balance_types

5121:
5122: Begin
5123: select balance_type_id
5124: into v_elig_bal_id
5125: from pay_balance_types
5126: where balance_name like p_ele_name||' Eligible Comp'
5127: and business_group_id + 0 = p_business_group_id ;
5128:
5129: exception when NO_DATA_FOUND then null;

Line 5203: from pay_balance_types

5199: AND rownum<2;
5200:
5201: select balance_type_id
5202: into v_at_not_taken_id
5203: from pay_balance_types
5204: where balance_name like p_ele_name||' AT Not Taken'
5205: and business_group_id + 0 = p_business_group_id ;
5206:
5207: select balance_type_id

Line 5209: from pay_balance_types

5205: and business_group_id + 0 = p_business_group_id ;
5206:
5207: select balance_type_id
5208: into v_at_elig_id
5209: from pay_balance_types
5210: where balance_name like p_ele_name||' AT Eligible Comp'
5211: and business_group_id + 0 = p_business_group_id ;
5212:
5213: select balance_type_id

Line 5215: from pay_balance_types

5211: and business_group_id + 0 = p_business_group_id ;
5212:
5213: select balance_type_id
5214: into v_at_overlimit_id
5215: from pay_balance_types
5216: where balance_name like p_ele_name||' AT Overlimit'
5217: and business_group_id + 0 = p_business_group_id ;
5218:
5219: assoc_bals(10) := v_at_bal_id;

Line 5248: from pay_balance_types

5244: assoc_eles(l_num_assoc_eles) := v_at_er_id;
5245:
5246: select balance_type_id
5247: into v_at_er_bal_id
5248: from pay_balance_types
5249: where balance_name like p_ele_name||' AT ER'
5250: and business_group_id + 0 = p_business_group_id ;
5251:
5252: assoc_bals(19) := v_at_er_bal_id;

Line 5264: from pay_balance_types

5260:
5261: begin
5262: select balance_type_id
5263: into v_overlimit_bal_id
5264: from pay_balance_types
5265: where balance_name like p_ele_name||' Overlimit'
5266: and business_group_id + 0 = p_business_group_id ;
5267:
5268: exception when NO_DATA_FOUND then null;

Line 5278: FROM pay_balance_types

5274: IF p_ele_ee_bond = 'Y' THEN
5275: BEGIN
5276: SELECT balance_type_id
5277: INTO v_refund_bal_id
5278: FROM pay_balance_types
5279: WHERE balance_name like p_ele_name||' Refund'
5280: AND business_group_id + 0 = p_business_group_id ;
5281: EXCEPTION
5282: WHEN NO_DATA_FOUND THEN

Line 5501: DELETE FROM pay_balance_types

5497: p_legislation_code => g_template_leg_code,
5498: p_mode => v_del_mode);
5499:
5500: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 60);
5501: DELETE FROM pay_balance_types
5502: WHERE balance_type_id = assoc_bals(i);
5503:
5504: END IF;
5505:

Line 5573: FROM pay_balance_types

5569: begin
5570:
5571: SELECT DISTINCT balance_type_id
5572: INTO v_bal_type_id
5573: FROM pay_balance_types
5574: WHERE balance_name = p_ele_name || ' ER' --Bug 3349594
5575: and business_group_id + 0 = p_business_group_id ;
5576:
5577: hr_balances.del_balance_type_cascade (

Line 5583: delete from PAY_BALANCE_TYPES

5579: p_legislation_code => g_template_leg_code,
5580: p_mode => v_del_mode);
5581:
5582: hr_utility.set_location('pyusuiet',165);
5583: delete from PAY_BALANCE_TYPES
5584: where balance_type_id = v_bal_type_id;
5585:
5586: exception when NO_DATA_FOUND then
5587: null;

Line 5642: FROM pay_balance_types

5638: begin
5639:
5640: SELECT DISTINCT balance_type_id
5641: INTO v_bal_type_id
5642: FROM pay_balance_types
5643: WHERE balance_name = p_ele_name || ' REFUND' --Bug 3349594
5644: and business_group_id + 0 = p_business_group_id ;
5645:
5646: hr_balances.del_balance_type_cascade (

Line 5652: delete from PAY_BALANCE_TYPES

5648: p_legislation_code => g_template_leg_code,
5649: p_mode => v_del_mode);
5650:
5651: hr_utility.set_location('pyusuiet',165);
5652: delete from PAY_BALANCE_TYPES
5653: where balance_type_id = v_bal_type_id;
5654:
5655: exception when NO_DATA_FOUND then
5656: null;