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
1023: IF p_brokerage_currency is not null and p_brokerage_code is not null then
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'