DBA Data[Home] [Help]

APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_TAX_BROKERAGE_SETUP_V

Line 979: from xtr_tax_brokerage_setup_v a, xtr_deduction_calcs_v b

975: end if;
976:
977: select count(*)
978: into l_count
979: from xtr_tax_brokerage_setup_v a, xtr_deduction_calcs_v b
980: where a.reference_code = p_brokerage_code
981: and a.deal_type = 'NI'
982: and a.deduction_type = 'B'
983: and a.deal_type = b.deal_type

Line 2288: from xtr_tax_brokerage_setup_v

2284: IS
2285: --
2286: cursor get_tax_info(p_tax_code VARCHAR2) is
2287: select tax_settle_method,calc_type
2288: from xtr_tax_brokerage_setup_v
2289: where reference_code = p_tax_code;
2290: --
2291: cursor get_tax_codes(p_deal_no NUMBER) is
2292: select tax_code,income_tax_code from xtr_deals