APPS.JAI_PO_TAX_PKG dependencies on JAI_RCV_LINE_TAXES

Line 215: jai_rcv_line_taxes

211: SELECT
212: tax_type
213: , third_party_flag
214: FROM
215: jai_rcv_line_taxes
216: WHERE shipment_line_id = p_line_id -- shipment line id
217: AND tax_id = pn_tax_id ; --added by erif on Feb 1,2008
218:
219: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;

Line 219: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;

215: jai_rcv_line_taxes
216: WHERE shipment_line_id = p_line_id -- shipment line id
217: AND tax_id = pn_tax_id ; --added by erif on Feb 1,2008
218:
219: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;
220: lv_third_party_flag jai_rcv_line_taxes.third_party_flag%TYPE;
221: -----------------------------------------------------------------------
222: --Add by Eric Ma for Retro Active Pricing Update on Jan 11, 2008 ,End
223:

Line 220: lv_third_party_flag jai_rcv_line_taxes.third_party_flag%TYPE;

216: WHERE shipment_line_id = p_line_id -- shipment line id
217: AND tax_id = pn_tax_id ; --added by erif on Feb 1,2008
218:
219: lv_tax_type jai_rcv_line_taxes.tax_type%TYPE;
220: lv_third_party_flag jai_rcv_line_taxes.third_party_flag%TYPE;
221: -----------------------------------------------------------------------
222: --Add by Eric Ma for Retro Active Pricing Update on Jan 11, 2008 ,End
223:
224: CURSOR Fetch_Item_Cur IS

Line 584: FROM jai_rcv_line_taxes A,

580: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
581: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
582: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
583: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
584: FROM jai_rcv_line_taxes A,
585: JAI_CMN_TAXES_ALL B,
586: jai_regime_tax_types_v aa
587: WHERE shipment_line_id = p_line_id /* shipment line id */
588: AND A.Tax_Id = B.Tax_Id

Line 1421: FROM jai_rcv_line_taxes A,

1417: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1418: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1419: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1420: , rsh.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
1421: FROM jai_rcv_line_taxes A,
1422: JAI_CMN_TAXES_ALL B,
1423: jai_regime_tax_types_v aa,
1424: RCV_SHIPMENT_HEADERS rsh --Added by Kevin Cheng
1425: WHERE shipment_line_id = p_line_id /* shipment line id */

Line 2008: UPDATE jai_rcv_line_taxes

2004: ELSE
2005: bsln_amt := p_price;
2006: END IF;
2007:
2008: UPDATE jai_rcv_line_taxes
2009: SET Tax_Amount = nvl(tax_amt_tab(I),0),
2010: Tax_Target_Amount = NVL(tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2011: WHERE shipment_Header_Id = p_header_id
2012: AND shipment_Line_Id = p_line_id