APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_CMN_TAXES_ALL

Line 951: jai_cmn_taxes_all

947: , NVL (tax_rate, -1) tax_rate
948: , tax_type
949: , NVL(rounding_factor,0) rounding_factor
950: FROM
951: jai_cmn_taxes_all
952: WHERE tax_id = pn_tax_id;
953:
954: CURSOR item_line_cur IS
955: SELECT

Line 3562: jai_cmn_taxes_all

3558: IS
3559: CURSOR get_inclusive_tax_flag IS
3560: SELECT NVL(inclusive_tax_flag,'N')
3561: FROM
3562: jai_cmn_taxes_all
3563: WHERE
3564: tax_id = pn_tax_id;
3565:
3566: lv_inclusive_tax_flag VARCHAR2(1);

Line 3856: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax

3852: , jcdt.source_doc_parent_line_no
3853: , jcta.inclusive_tax_flag inc_tax_flag --Added by Eric for Inclusive Tax
3854: FROM
3855: jai_cmn_document_taxes jcdt
3856: , jai_cmn_taxes_all jcta --Added by Eric for Inclusive Tax
3857: WHERE jcdt.source_doc_id = pn_invoice_id
3858: AND jcdt.source_doc_parent_line_no = pn_parent_line_number
3859: AND jcdt.tax_id = jcta.tax_id --Added by Eric for Inclusive Tax
3860: AND jcdt.source_doc_type = jai_constants.g_ap_standalone_invoice

Line 3923: jai_cmn_taxes_all

3919: , NVL (tax_rate, -1) tax_rate
3920: , tax_type
3921: , NVL(rounding_factor,0) rounding_factor
3922: FROM
3923: jai_cmn_taxes_all
3924: WHERE tax_id = pn_tax_id;
3925:
3926: CURSOR ap_invoice_dist_cur (pn_line_number NUMBER) IS
3927: SELECT