APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_TAX_BROKERAGE_SETUP

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 1261: from xtr_tax_brokerage_setup a,

1257: return true;
1258: end if;
1259: select count(*)
1260: into l_count
1261: from xtr_tax_brokerage_setup a,
1262: fnd_lookups lu, xtr_tax_deduction_calcs c
1263: where a.deal_type = 'NI'
1264: and lu.lookup_type='XTR_TAX_CALC_TYPES'
1265: and lu.lookup_code=a.calc_type

Line 1289: from xtr_tax_brokerage_setup a,

1285: return true;
1286: end if;
1287: select count(*)
1288: into l_count
1289: from xtr_tax_brokerage_setup a,
1290: fnd_lookups lu, xtr_tax_deduction_calcs c
1291: where a.deal_type = 'NI'
1292: and lu.lookup_type='XTR_TAX_CALC_TYPES'
1293: and lu.lookup_code=a.calc_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

Line 2342: from XTR_TAX_BROKERAGE_SETUP

2338: where m.CURRENCY = p_ccy;
2339: --
2340: cursor get_rounding_rules(p_tax_code VARCHAR2) is
2341: select tax_rounding_rule,tax_rounding_precision
2342: from XTR_TAX_BROKERAGE_SETUP
2343: where reference_code=p_tax_code;
2344: --
2345: v_rounding_rule VARCHAR2(1);
2346: v_rounding_precision VARCHAR2(20);

Line 2869: v_settle_method xtr_tax_brokerage_setup.tax_settle_method%Type;

2865: /*--------------------------------------------------------------------------------*/
2866: --
2867: v_rec xtr_fps2_p.one_step_rec_type;
2868: v_error VARCHAR2(40);
2869: v_settle_method xtr_tax_brokerage_setup.tax_settle_method%Type;
2870: --
2871: BEGIN
2872: --Principal Tax
2873: if g_prn_tax_settle_method='OSG' then