APPS.JA_JAINCVAT_XMLP_PKG dependencies on JAI_CMN_RG_OTHERS

Line 104: JAI_CMN_RG_OTHERS

100: SELECT
101: NVL(SUM(CREDIT)
102: ,0)
103: FROM
104: JAI_CMN_RG_OTHERS
105: WHERE SOURCE_REGISTER_ID = REGISTER_ID
106: AND SOURCE_TYPE = 1
107: AND TAX_TYPE in ( LV_TAX_TYPE_EXC_EDU_CESS , LV_TAX_TYPE_CVD_EDU_CESS );
108: BEGIN

Line 208: JAI_CMN_RG_OTHERS

204: SELECT
205: NVL(SUM(CREDIT)
206: ,0)
207: FROM
208: JAI_CMN_RG_OTHERS
209: WHERE SOURCE_REGISTER_ID = REGISTER_ID
210: AND SOURCE_TYPE = 1
211: AND TAX_TYPE in ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );
212: BEGIN

Line 247: JAI_CMN_RG_OTHERS

243: SELECT
244: SUM(NVL(CREDIT
245: ,0))
246: FROM
247: JAI_CMN_RG_OTHERS
248: WHERE SOURCE_TYPE = 4
249: AND SOURCE_REGISTER_ID = TRANSACTION_ID
250: AND TAX_TYPE IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' );
251: CURSOR C_SH_CESS_AMOUNT IS

Line 256: JAI_CMN_RG_OTHERS

252: SELECT
253: SUM(NVL(CREDIT
254: ,0))
255: FROM
256: JAI_CMN_RG_OTHERS
257: WHERE SOURCE_TYPE = 4
258: AND SOURCE_REGISTER_ID = TRANSACTION_ID
259: AND TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );
260: LN_CORRECTED_QTY NUMBER;