[Home] [Help]
1135: , NVL (tax_rate, -1) tax_rate
1136: , tax_type
1137: , NVL(rounding_factor,0) rounding_factor
1138: FROM
1139: jai_cmn_taxes_all
1140: WHERE tax_id = pn_tax_id;
1141:
1142: CURSOR item_line_cur IS
1143: SELECT
3126: NVL (tax_rate, -1) tax_rate,
3127: tax_type,
3128: NVL(reverse_charge_flag,'N') reverse_charge_flag, --Added by Qiong for reverse charge bug#16001407
3129: NVL(rounding_factor,0) rounding_factor
3130: FROM jai_cmn_taxes_all
3131: WHERE tax_id = pn_tax_id;
3132:
3133: /* changes done by abhidutt for bug 12358850. AP_INVOICE_DISTRIBUTIONS_ALL fetches no records when we directly enter Default-Distribution-Account without using distribution button for the invoice line
3134: in payables invoices. Added the cursor "get_assets_tracking_flag" so that asset_tracking_flag value will be fetched from the cursor instead of fetching it from SELECT query directly */
4213: IS
4214: CURSOR get_inclusive_tax_flag IS
4215: SELECT NVL(inclusive_tax_flag,'N')
4216: FROM
4217: jai_cmn_taxes_all
4218: WHERE
4219: tax_id = pn_tax_id;
4220:
4221: lv_inclusive_tax_flag VARCHAR2(1);
4536: , jcdt.source_doc_parent_line_no
4537: , jcta.inclusive_tax_flag inc_tax_flag --Added by Eric for Inclusive Tax
4538: FROM
4539: jai_cmn_document_taxes jcdt
4540: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
4541: WHERE jcdt.source_doc_id = pn_invoice_id
4542: AND jcdt.source_doc_parent_line_no = pn_parent_line_number
4543: AND jcdt.tax_id = jcta.tax_id --Added by Eric for Inclusive Tax
4544: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice
4614: , NVL (tax_rate, -1) tax_rate
4615: , tax_type
4616: , NVL(rounding_factor,0) rounding_factor
4617: FROM
4618: jai_cmn_taxes_all
4619: WHERE tax_id = pn_tax_id;
4620:
4621: CURSOR ap_invoice_dist_cur (pn_line_number NUMBER , pn_distribution_line_number number) IS /* Bug 13617527 -added pn_distribution_line_number */
4622: SELECT