eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_USER_INIT_DEDN dependencies on PAY_BALANCE_TYPES

Line 3610: pay_balance_types bt

3606:
3607: SELECT count(0)
3608: INTO already_exists
3609: FROM pay_defined_balances db,
3610: pay_balance_types bt
3611: WHERE db.balance_type_id = bt.balance_type_id
3612: AND bt.balance_name = p_bal_name
3613: AND db.balance_dimension_id = dim_id
3614: AND bt.business_group_id = v_business_group_id;

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

3673: -- Create associated balances for deductions.
3674: --
3675: -- "Primary" Balance:
3676: --
3677: /* Call pay_balance_types_pkg.chk_balance_type twice in order to check that
3678: the "Primary Balance" is ok to generate:
3679: procedure chk_balance_type
3680: (
3681: p_row_id varchar2,

Line 3693: pay_balance_types_pkg.chk_balance_type(

3689:
3690: hr_utility.set_location('pyusuidt',217);
3691: -- Check element name, ie. primary balance name, is unique to
3692: -- balances within this BG.
3693: pay_balance_types_pkg.chk_balance_type(
3694: p_row_id => NULL,
3695: p_business_group_id => p_bg_id,
3696: p_legislation_code => NULL,
3697: p_balance_name => p_ele_name,

Line 3704: pay_balance_types_pkg.chk_balance_type(

3700:
3701: hr_utility.set_location('pyusuidt',317);
3702: -- Check element name, ie. primary balance name, is unique to
3703: -- balances provided as startup data.
3704: pay_balance_types_pkg.chk_balance_type(
3705: p_row_id => NULL,
3706: p_business_group_id => NULL,
3707: p_legislation_code => 'US',
3708: p_balance_name => p_ele_name,

Line 4980: from pay_balance_types

4976:
4977: Begin
4978: select balance_type_id
4979: into v_not_taken_baltype_id
4980: from pay_balance_types
4981: where balance_name like p_ele_name||' Not Taken'
4982: and business_group_id + 0 = p_business_group_id ;
4983:
4984: exception when NO_DATA_FOUND then null;

Line 4999: from pay_balance_types

4995:
4996: Begin
4997: select balance_type_id
4998: into v_elig_bal_id
4999: from pay_balance_types
5000: where balance_name like p_ele_name||' Eligible Comp'
5001: and business_group_id + 0 = p_business_group_id ;
5002:
5003: exception when NO_DATA_FOUND then null;

Line 5077: from pay_balance_types

5073: AND rownum<2;
5074:
5075: select balance_type_id
5076: into v_at_not_taken_id
5077: from pay_balance_types
5078: where balance_name like p_ele_name||' AT Not Taken'
5079: and business_group_id + 0 = p_business_group_id ;
5080:
5081: select balance_type_id

Line 5083: from pay_balance_types

5079: and business_group_id + 0 = p_business_group_id ;
5080:
5081: select balance_type_id
5082: into v_at_elig_id
5083: from pay_balance_types
5084: where balance_name like p_ele_name||' AT Eligible Comp'
5085: and business_group_id + 0 = p_business_group_id ;
5086:
5087: select balance_type_id

Line 5089: from pay_balance_types

5085: and business_group_id + 0 = p_business_group_id ;
5086:
5087: select balance_type_id
5088: into v_at_overlimit_id
5089: from pay_balance_types
5090: where balance_name like p_ele_name||' AT Overlimit'
5091: and business_group_id + 0 = p_business_group_id ;
5092:
5093: assoc_bals(10) := v_at_bal_id;

Line 5122: from pay_balance_types

5118: assoc_eles(l_num_assoc_eles) := v_at_er_id;
5119:
5120: select balance_type_id
5121: into v_at_er_bal_id
5122: from pay_balance_types
5123: where balance_name like p_ele_name||' AT ER'
5124: and business_group_id + 0 = p_business_group_id ;
5125:
5126: assoc_bals(19) := v_at_er_bal_id;

Line 5138: from pay_balance_types

5134:
5135: begin
5136: select balance_type_id
5137: into v_overlimit_bal_id
5138: from pay_balance_types
5139: where balance_name like p_ele_name||' Overlimit'
5140: and business_group_id + 0 = p_business_group_id ;
5141:
5142: exception when NO_DATA_FOUND then null;

Line 5342: DELETE FROM pay_balance_types

5338: p_legislation_code => g_template_leg_code,
5339: p_mode => v_del_mode);
5340:
5341: hr_utility.set_location('hr_us_garn_gen.delete_dedn', 60);
5342: DELETE FROM pay_balance_types
5343: WHERE balance_type_id = assoc_bals(i);
5344:
5345: END IF;
5346:

Line 5414: FROM pay_balance_types

5410: begin
5411:
5412: SELECT DISTINCT balance_type_id
5413: INTO v_bal_type_id
5414: FROM pay_balance_types
5415: WHERE balance_name = p_ele_name || ' ER' --Bug 3349594
5416: and business_group_id + 0 = p_business_group_id ;
5417:
5418: hr_balances.del_balance_type_cascade (

Line 5424: delete from PAY_BALANCE_TYPES

5420: p_legislation_code => g_template_leg_code,
5421: p_mode => v_del_mode);
5422:
5423: hr_utility.set_location('pyusuiet',165);
5424: delete from PAY_BALANCE_TYPES
5425: where balance_type_id = v_bal_type_id;
5426:
5427: exception when NO_DATA_FOUND then
5428: null;

Line 5483: FROM pay_balance_types

5479: begin
5480:
5481: SELECT DISTINCT balance_type_id
5482: INTO v_bal_type_id
5483: FROM pay_balance_types
5484: WHERE balance_name = p_ele_name || ' REFUND' --Bug 3349594
5485: and business_group_id + 0 = p_business_group_id ;
5486:
5487: hr_balances.del_balance_type_cascade (

Line 5493: delete from PAY_BALANCE_TYPES

5489: p_legislation_code => g_template_leg_code,
5490: p_mode => v_del_mode);
5491:
5492: hr_utility.set_location('pyusuiet',165);
5493: delete from PAY_BALANCE_TYPES
5494: where balance_type_id = v_bal_type_id;
5495:
5496: exception when NO_DATA_FOUND then
5497: null;