APPS.JAI_PO_TAX_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 709: FROM Jai_cmn_document_Taxes A,

705: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
706: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
707: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
708: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
709: FROM Jai_cmn_document_Taxes A,
710: JAI_CMN_TAXES_ALL B,
711: jai_regime_tax_types_v aa
712: WHERE source_doc_line_id = p_line_id /* source doc line id */
713: AND A.Tax_Id = B.Tax_Id

Line 2136: FROM Jai_cmn_document_Taxes A,

2132: 'TDS', 2, 0)) tax_type_val,
2133: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2134: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
2135: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2136: FROM Jai_cmn_document_Taxes A,
2137: JAI_CMN_TAXES_ALL B,
2138: jai_regime_tax_types_v aa
2139: WHERE source_doc_line_id = p_line_id \* source doc line id *\
2140: AND A.Tax_Id = B.Tax_Id

Line 2742: UPDATE Jai_cmn_document_Taxes

2738: ELSE
2739: bsln_amt := p_price;
2740: END IF;
2741:
2742: UPDATE Jai_cmn_document_Taxes
2743: SET Tax_Amt = nvl(tax_amt_tab(I),0)
2744: WHERE source_doc_id = p_header_id
2745: AND source_doc_Line_Id = p_line_id
2746: AND Tax_Line_No = I;

Line 3793: FROM Jai_cmn_document_Taxes A,

3789: B.End_Date Valid_Date,
3790: B.rounding_factor rnd_factor,
3791: B.adhoc_flag adhoc_flag
3792: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3793: FROM Jai_cmn_document_Taxes A,
3794: JAI_CMN_TAXES_ALL B,
3795: jai_regime_tax_types_v aa
3796: WHERE source_doc_line_id = cp_source_doc_line_id
3797: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011

Line 3931: FROM Jai_cmn_document_Taxes A,

3927: A.currency_code curr,
3928: B.End_Date Valid_Date,
3929: B.rounding_factor rnd_factor,
3930: B.adhoc_flag adhoc_flag
3931: FROM Jai_cmn_document_Taxes A,
3932: JAI_CMN_TAXES_ALL B,
3933: jai_regime_tax_types_v aa
3934: WHERE source_doc_line_id = cp_source_doc_line_id
3935: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011

Line 6480: UPDATE jai_cmn_document_taxes

6476: FND_FILE.put_line(FND_FILE.LOG,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
6477: ', tax_target_tab -> '||tax_target_tab(i));
6478: END IF;
6479:
6480: UPDATE jai_cmn_document_taxes
6481: SET Tax_Amt = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6482: last_update_date = sysdate,
6483: last_updated_by = fnd_global.user_id,
6484: last_update_login = fnd_global.login_id