APPS.JAI_PO_TAX_PKG dependencies on JAI_RCV_LINE_TAXES

Line 259: jai_rcv_line_taxes

255: SELECT
256: tax_type
257: , third_party_flag
258: FROM
259: jai_rcv_line_taxes
260: WHERE shipment_line_id = p_line_id -- shipment line id
261: AND tax_id = pn_tax_id ; --added by erif on Feb 1,2008
262:
263: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;

Line 263: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;

259: jai_rcv_line_taxes
260: WHERE shipment_line_id = p_line_id -- shipment line id
261: AND tax_id = pn_tax_id ; --added by erif on Feb 1,2008
262:
263: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;
264: lv_third_party_flag jai_rcv_line_taxes.third_party_flag%TYPE;
265: -----------------------------------------------------------------------
266: --Add by Eric Ma for Retro Active Pricing Update on Jan 11, 2008 ,End
267:

Line 264: lv_third_party_flag jai_rcv_line_taxes.third_party_flag%TYPE;

260: WHERE shipment_line_id = p_line_id -- shipment line id
261: AND tax_id = pn_tax_id ; --added by erif on Feb 1,2008
262:
263: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;
264: lv_third_party_flag jai_rcv_line_taxes.third_party_flag%TYPE;
265: -----------------------------------------------------------------------
266: --Add by Eric Ma for Retro Active Pricing Update on Jan 11, 2008 ,End
267:
268: CURSOR Fetch_Item_Cur IS

Line 666: FROM jai_rcv_line_taxes A,

662: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
663: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
664: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
665: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
666: FROM jai_rcv_line_taxes A,
667: JAI_CMN_TAXES_ALL B,
668: jai_regime_tax_types_v aa
669: WHERE shipment_line_id = p_line_id /* shipment line id */
670: AND A.Tax_Id = B.Tax_Id

Line 2105: FROM jai_rcv_line_taxes A,

2101: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2102: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2103: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2104: , rsh.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
2105: FROM jai_rcv_line_taxes A,
2106: JAI_CMN_TAXES_ALL B,
2107: jai_regime_tax_types_v aa,
2108: RCV_SHIPMENT_HEADERS rsh --Added by Kevin Cheng
2109: WHERE shipment_line_id = p_line_id /* shipment line id */

Line 2717: UPDATE jai_rcv_line_taxes

2713: ELSE
2714: bsln_amt := p_price;
2715: END IF;
2716:
2717: UPDATE jai_rcv_line_taxes
2718: SET Tax_Amount = nvl(tax_amt_tab(I),0),
2719: Tax_Target_Amount = NVL(tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2720: WHERE shipment_Header_Id = p_header_id
2721: AND shipment_Line_Id = p_line_id