APPS.HR_GENERATE_PRETAX dependencies on PAY_BALANCE_TYPES

Line 487: pay_balance_types bt

483: */
484: SELECT count(0)
485: INTO already_exists
486: FROM pay_defined_balances db,
487: pay_balance_types bt
488: WHERE db.balance_type_id = bt.balance_type_id
489: AND upper(bt.balance_name) = upper(p_bal_name)
490: AND bt.business_group_id + 0 = v_business_group_id
491: AND db.balance_dimension_id = dim_id;

Line 3578: pay_balance_types pbt

3574: CURSOR get_pretax_bals IS
3575: SELECT pbc.balance_type_id
3576: FROM pay_balance_classifications pbc,
3577: pay_element_classifications pec,
3578: pay_balance_types pbt
3579: WHERE nvl(pbc.business_group_id, p_busgrp_id) = p_busgrp_id
3580: AND nvl(pbc.legislation_code, 'US') = 'US'
3581: AND pbc.classification_id = pec.classification_id
3582: AND pec.classification_name = 'Pre-Tax Deductions'

Line 3648: pay_balance_types pbt

3644:
3645: CURSOR get_pretax_catbals IS
3646: SELECT pbf.balance_type_id
3647: FROM pay_balance_feeds_f pbf,
3648: pay_balance_types pbt
3649: WHERE pbf.input_value_id = p_src_iv_id
3650: AND nvl(pbf.business_group_id, p_busgrp_id) = p_busgrp_id
3651: AND nvl(pbf.legislation_code, 'US') = 'US'
3652: AND pbt.balance_type_id = pbf.balance_type_id

Line 3796: -- DESC PAY_BALANCE_TYPES TO SEE COL LENGTHS.

3792:
3793: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',50);
3794:
3795: -- ARE WE ABSOLUTELY COMFORTABLE WITH REPORTING NAME = BAL NAME?!
3796: -- DESC PAY_BALANCE_TYPES TO SEE COL LENGTHS.
3797:
3798: -- Check balance name is unique to balances within this BG.
3799: pay_balance_types_pkg.chk_balance_type(
3800: p_row_id => NULL,

Line 3799: pay_balance_types_pkg.chk_balance_type(

3795: -- ARE WE ABSOLUTELY COMFORTABLE WITH REPORTING NAME = BAL NAME?!
3796: -- DESC PAY_BALANCE_TYPES TO SEE COL LENGTHS.
3797:
3798: -- Check balance name is unique to balances within this BG.
3799: pay_balance_types_pkg.chk_balance_type(
3800: p_row_id => NULL,
3801: p_business_group_id => p_bg_id,
3802: p_legislation_code => NULL,
3803: p_balance_name => dedn_assoc_bal_names(i),

Line 3810: pay_balance_types_pkg.chk_balance_type(

3806:
3807: hr_utility.set_location('hr_upgrade_earnings.upgrade_template',60);
3808:
3809: -- Also check balance name is unique to Startup data balances.
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 => dedn_assoc_bal_names(i),