APPS.JAI_PO_LLA_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 807: JAI_CMN_TAXES_ALL b

803: nvl(a.tax_amount,0) tax_amount,
804: nvl(b.adhoc_flag, 'N') adhoc_flag
805: FROM
806: JAI_PO_TAXES a ,
807: JAI_CMN_TAXES_ALL b
808: WHERE
809: a.tax_id = b.tax_id AND
810: a.po_line_id = v_po_line_id AND
811: a.po_header_id = v_po_hdr_id AND

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

1575: UPDATE JAI_PO_TAXES a
1576: SET tax_amount = (tax_amount * pr_new.quantity/ v_old_qty ),
1577: tax_target_amount = (tax_target_amount * pr_new.quantity/ v_old_qty)
1578: WHERE line_location_id = v_line_loc_id
1579: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');
1580:
1581: IF v_curr <> v_currency_code THEN
1582: v_currency_conv_rate := jai_cmn_utils_pkg.currency_conversion(v_gl_set_of_bks_id,
1583: v_curr, v_po_rate_date, v_po_rate_type, v_po_rate);