APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 958: JAI_CMN_TAXES_ALL b

954: nvl(a.tax_amount,0) tax_amount,
955: nvl(b.adhoc_flag, 'N') adhoc_flag
956: FROM
957: JAI_PO_TAXES a ,
958: JAI_CMN_TAXES_ALL b
959: WHERE
960: a.tax_id = b.tax_id AND
961: a.po_line_id = v_po_line_id AND
962: a.po_header_id = v_po_hdr_id AND

Line 1763: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');

1759: UPDATE JAI_PO_TAXES a
1760: SET tax_amount = (tax_amount * pr_new.quantity/ v_old_qty ),
1761: tax_target_amount = (tax_target_amount * pr_new.quantity/ v_old_qty)
1762: WHERE line_location_id = v_line_loc_id
1763: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');
1764:
1765: IF v_curr <> v_currency_code THEN
1766: v_currency_conv_rate := jai_cmn_utils_pkg.currency_conversion(v_gl_set_of_bks_id,
1767: v_curr, v_po_rate_date, v_po_rate_type, v_po_rate);