APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_CA_SOE_SUMM_BALANCES_V

Line 1039: from pay_ca_soe_summ_balances_v pcs

1035: begin
1036: if p_information_type <> 'DEDUCTIONS_SUMM' then
1037: select decode(p_dimension,'CURRENT',amount_current,'YTD',amount_ytd)
1038: into l_value
1039: from pay_ca_soe_summ_balances_v pcs
1040: where pcs.assignment_action_id = p_assignment_action_id
1041: and pcs.base_bal_name = decode(p_information_type,'GROSS_PAY_SUMM', /*balance_name changed to base_bal_name against bug#5169734*/
1042: 'Gross Pay',
1043: 'TAXABLE_BENEFIT_SUMM',

Line 1054: from pay_ca_soe_summ_balances_v pcs

1050: 'Payments');
1051: else
1052: select sum(decode(p_dimension,'CURRENT',amount_current,'YTD',amount_ytd))
1053: into l_value
1054: from pay_ca_soe_summ_balances_v pcs
1055: where pcs.assignment_action_id = p_assignment_action_id
1056: and pcs.balance_name in (
1057: 'Pre Tax Deductions',
1058: 'Involuntary Deductions',