APPS.JAI_PO_HOOK_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 869: INSERT INTO JAI_CMN_DOCUMENT_TAXES

865: IF NVL(lv_line_currency, '$$$') <> NVL(j_po_ll_rec.CURRENCY, '$$$') THEN
866: ln_func_Tax_amt := j_po_ll_rec.TAX_AMOUNT * ln_conv_rate;
867: END IF;
868:
869: INSERT INTO JAI_CMN_DOCUMENT_TAXES
870: (DOC_TAX_ID,
871: TAX_LINE_NO,
872: TAX_ID,
873: TAX_TYPE,

Line 904: (JAI_CMN_DOCUMENT_TAXES_s.NEXTVAL,

900: LAST_UPDATED_BY,
901: LAST_UPDATE_LOGIN,
902: VENDOR_ID)
903: VALUES
904: (JAI_CMN_DOCUMENT_TAXES_s.NEXTVAL,
905: j_po_ll_rec.TAX_LINE_NO,
906: j_po_ll_rec.TAX_ID,
907: j_po_ll_rec.TAX_TYPE,
908: j_po_ll_rec.CURRENCY,

Line 1258: FROM JAI_CMN_DOCUMENT_TAXES

1254:
1255: -- pramasub start
1256: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS
1257: SELECT source_doc_line_id, currency_code, SUM(tax_amt) tax_amount
1258: FROM JAI_CMN_DOCUMENT_TAXES
1259: WHERE source_doc_line_id = cp_cmn_line_id
1260: AND source_doc_type = cp_doc_type
1261: GROUP BY source_doc_line_id, currency_code;
1262: -- pramasub end

Line 1839: FROM JAI_CMN_DOCUMENT_TAXES

1835:
1836: -- pramasub start /*for asn/asbn*/
1837: CURSOR c_cmn_doc_taxes(cp_cmn_line_id IN NUMBER, cp_doc_type IN VARCHAR2) IS
1838: SELECT SUM(tax_amt) tax_amount, currency_code
1839: FROM JAI_CMN_DOCUMENT_TAXES
1840: WHERE source_doc_line_id = cp_cmn_line_id
1841: AND source_doc_type = cp_doc_type
1842: GROUP BY currency_code;
1843: -- pramasub end

Line 2476: jai_cmn_document_taxes jcdt

2472: jcdt.source_doc_line_id
2473: , jcdt.currency_code
2474: , SUM(jcdt.tax_amt) tax_amount
2475: FROM
2476: jai_cmn_document_taxes jcdt
2477: , jai_cmn_taxes_all jcta
2478: WHERE jcdt.source_doc_line_id = cp_cmn_line_id
2479: AND jcdt.source_doc_type = cp_doc_type
2480: AND jcta.tax_id = jcdt.tax_id