APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 1227: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat

1223: declare
1224: cursor c_chk_picking_tax_exists
1225: is
1226: select 1
1227: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat
1228: where line.tax_id = cat.tax_id
1229: and line.delivery_detail_id = p_source_trx_line_id
1230: and cat.tax_category_id = p_threshold_tax_cat_id;
1231: begin

Line 1278: insert into JAI_OM_WSH_LINE_TAXES

1274: exit when refc_tax_cur%notfound;
1275:
1276: if p_source_event = jai_constants.source_ttype_delivery then
1277: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'r_taxes.tax_id='||r_taxes.tax_id||', ln_exists='||ln_exists); */ --commented by bgowrava for bug#5631784
1278: insert into JAI_OM_WSH_LINE_TAXES
1279: ( picking_line_id
1280: , tax_line_no
1281: , precedence_1
1282: , precedence_2