APPS.PAY_AU_TERMINATIONS dependencies on PAY_BALANCE_DIMENSIONS

Line 1528: l_db_item_suffix pay_balance_dimensions.database_item_suffix%type;

1524: AND ppa.action_type IN ('Q','R','I','B'); /*Bug 4474896 - Introduced action_types 'B' and 'I'*/
1525:
1526: c_ytd_input_table c_get_ytd_def_bal_ids%rowtype;
1527: l_use_le_balances varchar2(50);
1528: l_db_item_suffix pay_balance_dimensions.database_item_suffix%type;
1529: l_payroll_id number;
1530: l_pay_eff_date DATE;
1531: l_flag number;
1532: l_eff_date DATE; /*Bug 4538463*/

Line 2261: pay_balance_dimensions pbd

2257: ,p_tax_unit_id
2258: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
2259: FROM pay_balance_types pbt,
2260: pay_defined_balances pdb,
2261: pay_balance_dimensions pbd
2262: WHERE pbt.legislation_code = 'AU'
2263: AND pbt.balance_name = c_balance_name
2264: AND pbt.balance_type_id = pdb.balance_type_id
2265: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 2614: pay_balance_dimensions pbd

2610: ,p_tax_unit_id
2611: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
2612: FROM pay_balance_types pbt,
2613: pay_defined_balances pdb,
2614: pay_balance_dimensions pbd
2615: WHERE pbt.legislation_code = 'AU'
2616: AND pbt.balance_name = c_balance_name
2617: AND pbt.balance_type_id = pdb.balance_type_id
2618: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 3419: pay_balance_dimensions pbd

3415: ,p_tax_unit_id
3416: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
3417: FROM pay_balance_types pbt,
3418: pay_defined_balances pdb,
3419: pay_balance_dimensions pbd
3420: WHERE pbt.legislation_code = 'AU'
3421: AND pbt.balance_name = c_balance_name
3422: AND pbt.balance_type_id = pdb.balance_type_id
3423: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 3744: pay_balance_dimensions pbd

3740: ,p_tax_unit_id
3741: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
3742: FROM pay_balance_types pbt,
3743: pay_defined_balances pdb,
3744: pay_balance_dimensions pbd
3745: WHERE pbt.legislation_code = 'AU'
3746: AND pbt.balance_name = c_balance_name
3747: AND pbt.balance_type_id = pdb.balance_type_id
3748: AND pbd.balance_dimension_id = pdb.balance_dimension_id

Line 3810: pay_balance_dimensions pbd

3806: ,NULL
3807: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL),0)
3808: FROM pay_balance_types pbt,
3809: pay_defined_balances pdb,
3810: pay_balance_dimensions pbd
3811: WHERE pbt.legislation_code = 'AU'
3812: AND pbt.balance_name = c_balance_name
3813: AND pbt.balance_type_id = pdb.balance_type_id
3814: AND pbd.balance_dimension_id = pdb.balance_dimension_id