743: )
744: IS
745: --
746: l_procedure VARCHAR2(100) ;
747: l_balance_name pay_balance_types.balance_name%TYPE;
748: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
749: --
750:
751: --
783: CURSOR csr_defined_balances
784: IS
785: SELECT defined.defined_balance_id
786: ,bal.balance_name balance_name
787: FROM pay_balance_types bal
788: , pay_balance_dimensions dim
789: , pay_defined_balances defined
790: WHERE bal.legislation_code = g_legislation_code
791: AND bal.balance_name IN ( 'Ordinary Taxable Earnings'