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_EARN dependencies on PAY_BALANCE_TYPES

Line 3500: pay_balance_types bt

3496:
3497: CURSOR get_reg_feeds (p_iv_id in number) IS
3498: SELECT f.balance_type_id
3499: FROM pay_balance_feeds_f f,
3500: pay_balance_types bt
3501: WHERE f.input_value_id = p_iv_id
3502: AND p_eff_start_date between f.effective_start_date
3503: and f.effective_end_date
3504: AND bt.balance_name not in ('FLSA Earnings','FLSA Hours')

Line 3645: pay_balance_types bt

3641: -- bug 962590 added FLSA Hours and FLSA Earnings check to cursor
3642: CURSOR get_reg_feeds (p_iv_id in number, p_business_group_id in number) IS
3643: SELECT f.balance_type_id
3644: FROM pay_balance_feeds_f f,
3645: pay_balance_types bt
3646: WHERE f.input_value_id = p_iv_id
3647: AND p_eff_start_date between f.effective_start_date
3648: and f.effective_end_date
3649: AND ( (bt.business_group_id is NULL and bt.legislation_code = 'US')

Line 3798: pay_balance_types_pkg.chk_balance_type(

3794: hr_utility.set_location('pyusuiet',795);
3795: -- Check element name, ie. primary balance name, is unique to
3796: -- balances within this BG.
3797:
3798: pay_balance_types_pkg.chk_balance_type(
3799: p_row_id => NULL,
3800: p_business_group_id => p_bg_id,
3801: p_legislation_code => NULL,
3802: p_balance_name => p_ele_name,

Line 3810: pay_balance_types_pkg.chk_balance_type(

3806: hr_utility.set_location('pyusuiet',800);
3807: -- Check element name, ie. primary balance name, is unique to
3808: -- balances provided as startup data.
3809:
3810: pay_balance_types_pkg.chk_balance_type(
3811: p_row_id => NULL,
3812: p_business_group_id => NULL,
3813: p_legislation_code => 'US',
3814: p_balance_name => p_ele_name,

Line 4880: FROM pay_balance_types

4876:
4877: hr_utility.set_location('pyusuiet',1100);
4878: SELECT balance_type_id
4879: INTO v_earn401k_bal_type_id
4880: FROM pay_balance_types
4881: WHERE balance_name = 'Earnings 401k'
4882: AND business_group_id IS NULL
4883: AND legislation_code = 'US';
4884:

Line 4913: FROM pay_balance_types

4909: begin
4910:
4911: SELECT balance_type_id
4912: INTO v_flsa_earnbal_id
4913: FROM pay_balance_types
4914: WHERE balance_name = 'FLSA Earnings'
4915: AND business_group_id IS NULL
4916: AND legislation_code = 'US';
4917:

Line 4956: FROM pay_balance_types

4952:
4953:
4954: SELECT balance_type_id
4955: INTO v_flsa_hrsbal_id
4956: FROM pay_balance_types
4957: WHERE balance_name = 'FLSA Hours'
4958: AND business_group_id IS NULL
4959: AND legislation_code = 'US';
4960:

Line 5056: from pay_balance_types

5052: -- Bug 3349586 - removed 'upper' to improve performance.
5053: --
5054: select balance_type_id
5055: into v_reghrs_bal_id
5056: from pay_balance_types
5057: where balance_name = 'Regular Hours Worked'
5058: and business_group_id is null
5059: and legislation_code = 'US';
5060:

Line 5110: from pay_balance_types

5106: -- Bug 3349586 - removed 'upper' to improve performance.
5107: --
5108: select balance_type_id
5109: into v_reghrs_bal_id
5110: from pay_balance_types
5111: where balance_name = 'Regular Hours Worked'
5112: and business_group_id is null
5113: and legislation_code = 'US';
5114: /*

Line 5117: from pay_balance_types

5113: and legislation_code = 'US';
5114: /*
5115: select balance_type_id
5116: into v_reghrs_bal_id
5117: from pay_balance_types
5118: where upper(balance_name ) = 'REGULAR HOURS WORKED'
5119: and business_group_id is null
5120: and legislation_code = 'US';
5121: */

Line 5152: from pay_balance_types

5148: -- Bug 3349586 - removed 'upper' to improve performance.
5149: --
5150: select balance_type_id
5151: into v_reghrs_bal_id
5152: from pay_balance_types
5153: where balance_name = 'Regular Salary Hours'
5154: and business_group_id is null
5155: and legislation_code = 'US';
5156:

Line 5187: from pay_balance_types

5183: -- Bug 3349586 - removed 'upper' to improve performance.
5184: --
5185: select balance_type_id
5186: into v_reghrs_bal_id
5187: from pay_balance_types
5188: where balance_name = 'Regular Wages Hours'
5189: and business_group_id is null
5190: and legislation_code = 'US';
5191:

Line 5505: delete from PAY_BALANCE_TYPES

5501: p_legislation_code => g_template_leg_code,
5502: p_mode => v_del_mode);
5503:
5504: hr_utility.set_location('pyusuiet',1261);
5505: delete from PAY_BALANCE_TYPES
5506: where balance_type_id = fnd_number.canonical_to_number(p_ele_info_10);
5507:
5508: END IF;
5509:

Line 5520: DELETE FROM pay_balance_types

5516: p_legislation_code => g_template_leg_code,
5517: p_mode => v_del_mode);
5518:
5519: hr_utility.set_location('pyusuiet', 1263);
5520: DELETE FROM pay_balance_types
5521: WHERE balance_type_id = fnd_number.canonical_to_number(p_ele_info_12);
5522:
5523: END IF;
5524:

Line 5539: from pay_balance_types

5535: -- Bug 3349586 - removed 'upper' to improve performance.
5536: --
5537: select balance_type_id
5538: into v_negearn_bal_type_id
5539: from pay_balance_types
5540: where balance_name = v_negearn_bal_name and
5541: business_group_id + 0 = p_business_group_id ;
5542:
5543: hr_utility.set_location('pyusuiet',164);

Line 5550: delete from PAY_BALANCE_TYPES

5546: p_legislation_code => g_template_leg_code,
5547: p_mode => v_del_mode);
5548:
5549: hr_utility.set_location('pyusuiet',1265);
5550: delete from PAY_BALANCE_TYPES
5551: where balance_type_id = v_negearn_bal_type_id;
5552:
5553: exception when NO_DATA_FOUND then
5554: null;

Line 5571: from pay_balance_types

5567:
5568: hr_utility.set_location('pyusuiet',1267);
5569: select balance_type_id
5570: into v_addl_bal_type_id
5571: from pay_balance_types
5572: where balance_name = v_addl_bal_name and
5573: business_group_id + 0 = p_business_group_id ;
5574:
5575: hr_utility.set_location('pyusuiet',1268);

Line 5582: delete from PAY_BALANCE_TYPES

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

Line 5604: from pay_balance_types

5600:
5601: hr_utility.set_location('pyusuiet',1270);
5602: select balance_type_id
5603: into v_repl_bal_type_id
5604: from pay_balance_types
5605: where balance_name = v_repl_bal_name and
5606: business_group_id + 0 = p_business_group_id ;
5607:
5608: hr_utility.set_location('pyusuiet',1275);

Line 5615: delete from PAY_BALANCE_TYPES

5611: p_legislation_code => g_template_leg_code,
5612: p_mode => v_del_mode);
5613:
5614: hr_utility.set_location('pyusuiet',1280);
5615: delete from PAY_BALANCE_TYPES
5616: where balance_type_id = v_repl_bal_type_id;
5617:
5618: exception when NO_DATA_FOUND then
5619: null;