[Home] [Help]
3498:
3499: CURSOR get_reg_feeds (p_iv_id in number) IS
3500: SELECT f.balance_type_id
3501: FROM pay_balance_feeds_f f,
3502: pay_balance_types bt
3503: WHERE f.input_value_id = p_iv_id
3504: AND p_eff_start_date between f.effective_start_date
3505: and f.effective_end_date
3506: AND bt.balance_name not in ('FLSA Earnings','FLSA Hours')
3643: -- bug 962590 added FLSA Hours and FLSA Earnings check to cursor
3644: CURSOR get_reg_feeds (p_iv_id in number, p_business_group_id in number) IS
3645: SELECT f.balance_type_id
3646: FROM pay_balance_feeds_f f,
3647: pay_balance_types bt
3648: WHERE f.input_value_id = p_iv_id
3649: AND p_eff_start_date between f.effective_start_date
3650: and f.effective_end_date
3651: AND ( (bt.business_group_id is NULL and bt.legislation_code = 'US')
3796: hr_utility.set_location('pyusuiet',795);
3797: -- Check element name, ie. primary balance name, is unique to
3798: -- balances within this BG.
3799:
3800: pay_balance_types_pkg.chk_balance_type(
3801: p_row_id => NULL,
3802: p_business_group_id => p_bg_id,
3803: p_legislation_code => NULL,
3804: p_balance_name => p_ele_name,
3808: hr_utility.set_location('pyusuiet',800);
3809: -- Check element name, ie. primary balance name, is unique to
3810: -- balances provided as startup data.
3811:
3812: pay_balance_types_pkg.chk_balance_type(
3813: p_row_id => NULL,
3814: p_business_group_id => NULL,
3815: p_legislation_code => 'US',
3816: p_balance_name => p_ele_name,
4878:
4879: hr_utility.set_location('pyusuiet',1100);
4880: SELECT balance_type_id
4881: INTO v_earn401k_bal_type_id
4882: FROM pay_balance_types
4883: WHERE balance_name = 'Earnings 401k'
4884: AND business_group_id IS NULL
4885: AND legislation_code = 'US';
4886:
4911: begin
4912:
4913: SELECT balance_type_id
4914: INTO v_flsa_earnbal_id
4915: FROM pay_balance_types
4916: WHERE balance_name = 'FLSA Earnings'
4917: AND business_group_id IS NULL
4918: AND legislation_code = 'US';
4919:
4954:
4955:
4956: SELECT balance_type_id
4957: INTO v_flsa_hrsbal_id
4958: FROM pay_balance_types
4959: WHERE balance_name = 'FLSA Hours'
4960: AND business_group_id IS NULL
4961: AND legislation_code = 'US';
4962:
5054: -- Bug 3349586 - removed 'upper' to improve performance.
5055: --
5056: select balance_type_id
5057: into v_reghrs_bal_id
5058: from pay_balance_types
5059: where balance_name = 'Regular Hours Worked'
5060: and business_group_id is null
5061: and legislation_code = 'US';
5062:
5108: -- Bug 3349586 - removed 'upper' to improve performance.
5109: --
5110: select balance_type_id
5111: into v_reghrs_bal_id
5112: from pay_balance_types
5113: where balance_name = 'Regular Hours Worked'
5114: and business_group_id is null
5115: and legislation_code = 'US';
5116: /*
5115: and legislation_code = 'US';
5116: /*
5117: select balance_type_id
5118: into v_reghrs_bal_id
5119: from pay_balance_types
5120: where upper(balance_name ) = 'REGULAR HOURS WORKED'
5121: and business_group_id is null
5122: and legislation_code = 'US';
5123: */
5150: -- Bug 3349586 - removed 'upper' to improve performance.
5151: --
5152: select balance_type_id
5153: into v_reghrs_bal_id
5154: from pay_balance_types
5155: where balance_name = 'Regular Salary Hours'
5156: and business_group_id is null
5157: and legislation_code = 'US';
5158:
5185: -- Bug 3349586 - removed 'upper' to improve performance.
5186: --
5187: select balance_type_id
5188: into v_reghrs_bal_id
5189: from pay_balance_types
5190: where balance_name = 'Regular Wages Hours'
5191: and business_group_id is null
5192: and legislation_code = 'US';
5193:
5503: p_legislation_code => g_template_leg_code,
5504: p_mode => v_del_mode);
5505:
5506: hr_utility.set_location('pyusuiet',1261);
5507: delete from PAY_BALANCE_TYPES
5508: where balance_type_id = fnd_number.canonical_to_number(p_ele_info_10);
5509:
5510: END IF;
5511:
5518: p_legislation_code => g_template_leg_code,
5519: p_mode => v_del_mode);
5520:
5521: hr_utility.set_location('pyusuiet', 1263);
5522: DELETE FROM pay_balance_types
5523: WHERE balance_type_id = fnd_number.canonical_to_number(p_ele_info_12);
5524:
5525: END IF;
5526:
5537: -- Bug 3349586 - removed 'upper' to improve performance.
5538: --
5539: select balance_type_id
5540: into v_negearn_bal_type_id
5541: from pay_balance_types
5542: where balance_name = v_negearn_bal_name and
5543: business_group_id + 0 = p_business_group_id ;
5544:
5545: hr_utility.set_location('pyusuiet',164);
5548: p_legislation_code => g_template_leg_code,
5549: p_mode => v_del_mode);
5550:
5551: hr_utility.set_location('pyusuiet',1265);
5552: delete from PAY_BALANCE_TYPES
5553: where balance_type_id = v_negearn_bal_type_id;
5554:
5555: exception when NO_DATA_FOUND then
5556: null;
5569:
5570: hr_utility.set_location('pyusuiet',1267);
5571: select balance_type_id
5572: into v_addl_bal_type_id
5573: from pay_balance_types
5574: where balance_name = v_addl_bal_name and
5575: business_group_id + 0 = p_business_group_id ;
5576:
5577: hr_utility.set_location('pyusuiet',1268);
5580: p_legislation_code => g_template_leg_code,
5581: p_mode => v_del_mode);
5582:
5583: hr_utility.set_location('pyusuiet',1268);
5584: delete from PAY_BALANCE_TYPES
5585: where balance_type_id = v_addl_bal_type_id;
5586:
5587: exception when NO_DATA_FOUND then
5588: null;
5602:
5603: hr_utility.set_location('pyusuiet',1270);
5604: select balance_type_id
5605: into v_repl_bal_type_id
5606: from pay_balance_types
5607: where balance_name = v_repl_bal_name and
5608: business_group_id + 0 = p_business_group_id ;
5609:
5610: hr_utility.set_location('pyusuiet',1275);
5613: p_legislation_code => g_template_leg_code,
5614: p_mode => v_del_mode);
5615:
5616: hr_utility.set_location('pyusuiet',1280);
5617: delete from PAY_BALANCE_TYPES
5618: where balance_type_id = v_repl_bal_type_id;
5619:
5620: exception when NO_DATA_FOUND then
5621: null;