DBA Data[Home] [Help]

APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 745: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

741: IS
742: --
743: l_procedure VARCHAR2(100) ;
744: l_balance_name pay_balance_types.balance_name%TYPE;
745: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
746: --
747:
748: --
749: -- Cursor to fetch element type id and input value id for 'SSCWT Information' element

Line 786: , pay_defined_balances defined

782: SELECT defined.defined_balance_id
783: ,bal.balance_name balance_name
784: FROM pay_balance_types bal
785: , pay_balance_dimensions dim
786: , pay_defined_balances defined
787: WHERE bal.legislation_code = g_legislation_code
788: AND bal.balance_name IN ( 'Ordinary Taxable Earnings'
789: ,'Extra Emolument Taxable Earnings'
790: ,'KiwiSaver Employer Contributions'