DBA Data[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 1019: FROM JAI_CMN_TAX_CTG_LINES CATL,

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
1022: WHERE CATL.TAX_CATEGORY_ID = CP_TAX_CATEGORY_ID
1023: AND CATL.TAX_ID = CODES.TAX_ID