DBA Data[Home] [Help]

APPS.XTR_FX_TRANSFERS_PKG dependencies on XTR_DEDUCTION_CALCS_V

Line 848: from xtr_tax_brokerage_setup_v a, xtr_deduction_calcs_v b

844: IF p_brokerage_code is not null then
845: BEGIN
846: select 'Y'
847: into l_temp
848: from xtr_tax_brokerage_setup_v a, xtr_deduction_calcs_v b
849: where a.reference_code = p_brokerage_code
850: and a.deal_type = G_Fx_Deal_Type
851: and a.deduction_type = 'B'
852: and a.deal_type = b.deal_type

Line 1028: xtr_deduction_calcs_v d

1024: BEGIN
1025: select d.amount_type
1026: into l_amount_type
1027: from xtr_tax_brokerage_setup a,
1028: xtr_deduction_calcs_v d
1029: where a.deal_type = p_deal_type
1030: and a.reference_code = p_brokerage_code
1031: and nvl(a.authorised,'N')= 'Y'
1032: and d.deal_type = a.deal_type