DBA Data[Home] [Help]

APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 747: l_balance_name pay_balance_types.balance_name%TYPE;

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: --

Line 787: FROM pay_balance_types bal

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'