DBA Data[Home] [Help]

APPS.PAY_IN_SOE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 549: , pay_balance_dimensions pbd

545: CURSOR csr_get_tax_till_date
546: IS
547: SELECT SUM(pay_balance_pkg.get_value( pdb.defined_balance_id, p_assignment_action_id)) COL16
548: FROM pay_balance_types pbt
549: , pay_balance_dimensions pbd
550: , pay_defined_balances pdb
551: WHERE pbt.balance_name IN ( 'F16 Income Tax till Date'
552: , 'F16 Surcharge till Date'
553: , 'F16 Education Cess till Date'

Line 584: , pay_balance_dimensions pbd

580: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)),
581: TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id,'|| p_assignment_action_id ||')
582: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40))) COL16
583: FROM pay_balance_types pbt
584: , pay_balance_dimensions pbd
585: , pay_defined_balances pdb
586: WHERE pbt.balance_name IN ( ''F16 Salary Under Section 17''
587: , ''F16 Value of Perquisites''
588: , ''F16 Profit in lieu of Salary''