DBA Data[Home] [Help]

APPS.JA_JAIN23D_XMLP_PKG dependencies on JAI_CMN_RG_OTHERS

Line 706: JAI_CMN_RG_OTHERS RGOTH

702: CURSOR CUR_GET_CESS_AMT IS
703: SELECT
704: SUM(DEBIT) TAX_VAL
705: FROM
706: JAI_CMN_RG_OTHERS RGOTH
707: WHERE RGOTH.SOURCE_TYPE = 3
708: AND RGOTH.SOURCE_REGISTER_ID = REGISTER_ID
709: AND RGOTH.TAX_TYPE in ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' );
710: BEGIN

Line 737: JAI_CMN_RG_OTHERS RGOTH

733: CURSOR CUR_GET_CESS_AMT IS
734: SELECT
735: SUM(CREDIT) TAX_VAL
736: FROM
737: JAI_CMN_RG_OTHERS RGOTH
738: WHERE RGOTH.SOURCE_TYPE = 3
739: AND RGOTH.SOURCE_REGISTER_ID = REGISTER_ID
740: AND RGOTH.TAX_TYPE in ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' );
741: BEGIN

Line 774: JAI_CMN_RG_OTHERS RGOTH

770: CURSOR CUR_GET_CESS_AMT IS
771: SELECT
772: SUM(DEBIT) TAX_VAL
773: FROM
774: JAI_CMN_RG_OTHERS RGOTH
775: WHERE RGOTH.SOURCE_TYPE = 3
776: AND RGOTH.SOURCE_REGISTER_ID = REGISTER_ID
777: AND RGOTH.TAX_TYPE in ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );
778: BEGIN

Line 805: JAI_CMN_RG_OTHERS RGOTH

801: CURSOR CUR_GET_CESS_AMT IS
802: SELECT
803: SUM(CREDIT) TAX_VAL
804: FROM
805: JAI_CMN_RG_OTHERS RGOTH
806: WHERE RGOTH.SOURCE_TYPE = 3
807: AND RGOTH.SOURCE_REGISTER_ID = REGISTER_ID
808: AND RGOTH.TAX_TYPE in ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );
809: BEGIN