DBA Data[Home] [Help]

APPS.PAY_IN_SOE_PKG dependencies on PAY_DEFINED_BALANCES

Line 550: , pay_defined_balances pdb

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'
554: , 'F16 Sec and HE Cess till Date')

Line 585: , pay_defined_balances pdb

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''
589: , ''F16 Gross Salary''

Line 824: FROM pay_defined_balances pdb

820: g_sql := 'SELECT org.org_information7 COL02
821: , TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id
822: , ' || p_assignment_action_id || ')
823: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
824: FROM pay_defined_balances pdb
825: , hr_organization_information_v org
826: WHERE org.organization_id = ' || l_business_group_id || '
827: AND org.org_information_context = ''Business Group:SOE Detail''
828: AND org.org_information1 = ''BALANCE''