APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_CA_SOE_SUMM_BALANCES_V

Line 986: from pay_ca_soe_summ_balances_v pcs

982: begin
983: if p_information_type <> 'DEDUCTIONS_SUMM' then
984: select decode(p_dimension,'CURRENT',amount_current,'YTD',amount_ytd)
985: into l_value
986: from pay_ca_soe_summ_balances_v pcs
987: where pcs.assignment_action_id = p_assignment_action_id
988: and pcs.base_bal_name = decode(p_information_type,'GROSS_PAY_SUMM', /*balance_name changed to base_bal_name against bug#5169734*/
989: 'Gross Pay',
990: 'TAXABLE_BENEFIT_SUMM',

Line 1001: from pay_ca_soe_summ_balances_v pcs

997: 'Payments');
998: else
999: select sum(decode(p_dimension,'CURRENT',amount_current,'YTD',amount_ytd))
1000: into l_value
1001: from pay_ca_soe_summ_balances_v pcs
1002: where pcs.assignment_action_id = p_assignment_action_id
1003: and pcs.balance_name in (
1004: 'Pre Tax Deductions',
1005: 'Involuntary Deductions',