APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 1130: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat

1126: declare
1127: cursor c_chk_picking_tax_exists
1128: is
1129: select 1
1130: from JAI_OM_WSH_LINE_TAXES line, JAI_CMN_TAX_CTG_LINES cat
1131: where line.tax_id = cat.tax_id
1132: and line.delivery_detail_id = p_source_trx_line_id
1133: and cat.tax_category_id = p_threshold_tax_cat_id;
1134: begin

Line 1181: insert into JAI_OM_WSH_LINE_TAXES

1177: exit when refc_tax_cur%notfound;
1178:
1179: if p_source_event = jai_constants.source_ttype_delivery then
1180: /* 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
1181: insert into JAI_OM_WSH_LINE_TAXES
1182: ( picking_line_id
1183: , tax_line_no
1184: , precedence_1
1185: , precedence_2