APPS.JAI_PO_HOOK_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 777: INSERT INTO JAI_CMN_DOCUMENT_TAXES

773: IF NVL(lv_line_currency, '$$$') <> NVL(j_po_ll_rec.CURRENCY, '$$$') THEN
774: ln_func_Tax_amt := j_po_ll_rec.TAX_AMOUNT * ln_conv_rate;
775: END IF;
776:
777: INSERT INTO JAI_CMN_DOCUMENT_TAXES
778: (DOC_TAX_ID,
779: TAX_LINE_NO,
780: TAX_ID,
781: TAX_TYPE,

Line 812: (JAI_CMN_DOCUMENT_TAXES_s.NEXTVAL,

808: LAST_UPDATED_BY,
809: LAST_UPDATE_LOGIN,
810: VENDOR_ID)
811: VALUES
812: (JAI_CMN_DOCUMENT_TAXES_s.NEXTVAL,
813: j_po_ll_rec.TAX_LINE_NO,
814: j_po_ll_rec.TAX_ID,
815: j_po_ll_rec.TAX_TYPE,
816: j_po_ll_rec.CURRENCY,

Line 1129: FROM JAI_CMN_DOCUMENT_TAXES

1125:
1126: -- pramasub start
1127: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS
1128: SELECT source_doc_line_id, currency_code, SUM(tax_amt) tax_amount
1129: FROM JAI_CMN_DOCUMENT_TAXES
1130: WHERE source_doc_line_id = cp_cmn_line_id
1131: AND source_doc_type = cp_doc_type
1132: GROUP BY source_doc_line_id, currency_code;
1133: -- pramasub end

Line 1702: FROM JAI_CMN_DOCUMENT_TAXES

1698:
1699: -- pramasub start /*for asn/asbn*/
1700: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS
1701: SELECT SUM(tax_amt) tax_amount, currency_code
1702: FROM JAI_CMN_DOCUMENT_TAXES
1703: WHERE source_doc_line_id = cp_cmn_line_id
1704: AND source_doc_type = cp_doc_type
1705: GROUP BY currency_code;
1706: -- pramasub end

Line 2274: jai_cmn_document_taxes jcdt

2270: jcdt.source_doc_line_id
2271: , jcdt.currency_code
2272: , SUM(jcdt.tax_amt) tax_amount
2273: FROM
2274: jai_cmn_document_taxes jcdt
2275: , jai_cmn_taxes_all jcta
2276: WHERE jcdt.source_doc_line_id = cp_cmn_line_id
2277: AND jcdt.source_doc_type = cp_doc_type
2278: AND jcta.tax_id = jcdt.tax_id