[Home] [Help]
2255: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
2256: ,c_max_assignment_action_id
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
2608: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
2609: ,c_max_assignment_action_id
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
3413: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3414: ,c_max_assignment_action_id
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
3738: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3739: ,c_max_assignment_action_id
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
3804: SELECT nvl(pay_balance_pkg.get_value(pdb.defined_balance_id
3805: ,c_max_assignment_action_id
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
3815: AND pbd.dimension_name = '_ASG_YTD';
3816:
3817: cursor csr_get_balance_name is
3818: select pbt.balance_name
3819: from pay_balance_types pbt
3820: where pbt.balance_name in ('Earnings_Standard'
3821: ,'Earnings_Leave_Loading'
3822: ,'Earnings_Additional'
3823: ,'Earnings_Spread'