APPS.JAI_PO_TAX_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 622: FROM Jai_cmn_document_Taxes A,

618: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
619: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
620: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
621: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
622: FROM Jai_cmn_document_Taxes A,
623: JAI_CMN_TAXES_ALL B,
624: jai_regime_tax_types_v aa
625: WHERE source_doc_line_id = p_line_id /* source doc line id */
626: AND A.Tax_Id = B.Tax_Id

Line 1452: FROM Jai_cmn_document_Taxes A,

1448: 'TDS', 2, 0)) tax_type_val,
1449: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1450: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
1451: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1452: FROM Jai_cmn_document_Taxes A,
1453: JAI_CMN_TAXES_ALL B,
1454: jai_regime_tax_types_v aa
1455: WHERE source_doc_line_id = p_line_id \* source doc line id *\
1456: AND A.Tax_Id = B.Tax_Id

Line 2029: UPDATE Jai_cmn_document_Taxes

2025: ELSE
2026: bsln_amt := p_price;
2027: END IF;
2028:
2029: UPDATE Jai_cmn_document_Taxes
2030: SET Tax_Amt = nvl(tax_amt_tab(I),0)
2031: WHERE source_doc_id = p_header_id
2032: AND source_doc_Line_Id = p_line_id
2033: AND Tax_Line_No = I;

Line 3016: FROM Jai_cmn_document_Taxes A,

3012: B.End_Date Valid_Date,
3013: B.rounding_factor rnd_factor,
3014: B.adhoc_flag adhoc_flag
3015: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3016: FROM Jai_cmn_document_Taxes A,
3017: JAI_CMN_TAXES_ALL B,
3018: jai_regime_tax_types_v aa
3019: WHERE source_doc_line_id = cp_source_doc_line_id
3020: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011

Line 3141: FROM Jai_cmn_document_Taxes A,

3137: A.currency_code curr,
3138: B.End_Date Valid_Date,
3139: B.rounding_factor rnd_factor,
3140: B.adhoc_flag adhoc_flag
3141: FROM Jai_cmn_document_Taxes A,
3142: JAI_CMN_TAXES_ALL B,
3143: jai_regime_tax_types_v aa
3144: WHERE source_doc_line_id = cp_source_doc_line_id
3145: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011

Line 5091: UPDATE jai_cmn_document_taxes

5087: FND_FILE.put_line(FND_FILE.LOG,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
5088: ', tax_target_tab -> '||tax_target_tab(i));
5089: END IF;
5090:
5091: UPDATE jai_cmn_document_taxes
5092: SET Tax_Amt = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5093: last_update_date = sysdate,
5094: last_updated_by = fnd_global.user_id,
5095: last_update_login = fnd_global.login_id