APPS.JAI_AR_TRX_LINES_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 486: FROM JAI_CMN_TAX_CTG_LINES CATL,

482: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
483: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
484: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
485: SELECT COUNT(1)
486: FROM JAI_CMN_TAX_CTG_LINES CATL,
487: JAI_CMN_TAXES_ALL CODES,
488: JAI_REGIME_TAX_TYPES_V JRTTV
489: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
490: AND CATL.TAX_ID = CODES.TAX_ID

Line 1470: FROM JAI_CMN_TAX_CTG_LINES A

1466: WHERE customer_trx_id = v_header_id;
1467:
1468: Cursor tax_id_cur(p_tax_category_id IN Number) IS
1469: SELECT line_no
1470: FROM JAI_CMN_TAX_CTG_LINES A
1471: WHERE A.tax_category_id = p_tax_category_id
1472: ORDER BY line_no;
1473:
1474: Cursor address_cur(p_ship_to_site_use_id IN Number) IS