APPS.PAY_IN_SOE_PKG dependencies on PAY_BALANCE_PKG

Line 547: SELECT SUM(pay_balance_pkg.get_value( pdb.defined_balance_id, p_assignment_action_id)) COL16

543: IS
544:
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'

Line 581: TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id,'|| p_assignment_action_id ||')

577: ,SUBSTR(pbt.balance_name,5)) COL04
578: , DECODE(pbt.balance_name,''F16 Income Tax till Date'',
579: TO_CHAR('||l_tax_till_date||'
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

Line 821: , TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id

817: FETCH csr_get_tax_unit_id INTO l_tax_unit_id;
818: CLOSE csr_get_tax_unit_id;
819:
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