[Home] [Help]
1013: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
1014:
1015: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
1016: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
1017: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
1018: SELECT COUNT(1)
1019: FROM JAI_CMN_TAX_CTG_LINES CATL,
1020: JAI_CMN_TAXES_ALL CODES,
1021: JAI_REGIME_TAX_TYPES_V JRTTV