DBA Data[Home] [Help]

APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 748: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

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: --
752: -- Cursor to fetch element type id and input value id for 'SSCWT Information' element

Line 789: , pay_defined_balances defined

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'
792: ,'Extra Emolument Taxable Earnings'
793: ,'KiwiSaver Employer Contributions'