APPS.JAI_OPEN_API_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 4501: CURSOR chk_tax_category_cur(cn_tax_category_id JAI_CMN_TAX_CTG_LINES.tax_category_id%type)

4497: FROM JAI_INTERFACE_LINES_ALL
4498: WHERE INTERFACE_LINE_ID = pn_interface_line_id;
4499:
4500:
4501: CURSOR chk_tax_category_cur(cn_tax_category_id JAI_CMN_TAX_CTG_LINES.tax_category_id%type)
4502: IS
4503: SELECT
4504: count(tax.tax_id)
4505: FROM JAI_CMN_TAXES_ALL tax,

Line 4506: JAI_CMN_TAX_CTG_LINES cate

4502: IS
4503: SELECT
4504: count(tax.tax_id)
4505: FROM JAI_CMN_TAXES_ALL tax,
4506: JAI_CMN_TAX_CTG_LINES cate
4507: WHERE cate.tax_id = tax.tax_id
4508: and cate.tax_category_id = cn_tax_category_id
4509: and (
4510: upper(tax_type) in

Line 10763: -- Will fetch taxes from JAI_CMN_TAX_CTG_LINES

10759: );
10760:
10761: ELSE -- No related tax lines in JAI_INTERFACE_TAX_LINES_ALL, tax category will be used.
10762: -- Tax_category_id is populated in jai_interface_lines_all during VALIDATION phase.
10763: -- Will fetch taxes from JAI_CMN_TAX_CTG_LINES
10764:
10765: SELECT tax_category_id
10766: INTO ln_tax_category_id
10767: FROM jai_interface_lines_all

Line 10797: , 'JAI_CMN_TAX_CTG_LINES'

10793: );
10794: lv_tax_sql :=
10795: REPLACE( lv_tax_sql
10796: , '$$TAX_SOURCE_TABLE$$'
10797: , 'JAI_CMN_TAX_CTG_LINES'
10798: );
10799: -- replace join condition
10800: lv_tax_sql :=
10801: REPLACE( lv_tax_sql