APPS.JA_JAINMCEN_XMLP_PKG dependencies on JAI_CMN_RG_OTHERS

Line 490: JAI_CMN_RG_OTHERS

486: NVL(SUM(CREDIT)
487: ,0) - NVL(SUM(DEBIT)
488: ,0)
489: FROM
490: JAI_CMN_RG_OTHERS
491: WHERE SOURCE_REGISTER_ID = CP_REG_ID
492: AND SOURCE_TYPE = 1
493: AND TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' );
494: CURSOR CUR_EDU_CESS_RND_AMT(CP_REG_ID IN NUMBER) IS

Line 500: JAI_CMN_RG_OTHERS

496: NVL(SUM(CREDIT)
497: ,0) - NVL(SUM(DEBIT)
498: ,0)
499: FROM
500: JAI_CMN_RG_OTHERS
501: WHERE SOURCE_REGISTER_ID = CP_REG_ID
502: AND SOURCE_TYPE = 1
503: AND TAX_TYPE IN ( LV_TAX_TYPE_EXC_EDU_CESS , LV_TAX_TYPE_CVD_EDU_CESS );
504: V_ROUND_AMOUNT JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE := 0;

Line 582: LV_SOURCE_REGISTER_TYPE JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE;

578: FUNCTION CF_EDUCATION_CESSFORMULA(EXCISE_INVOICE_NO2 IN VARCHAR2
579: ,EXCISE_INVOICE_DATE2 IN DATE
580: ,REGISTER_ID IN NUMBER) RETURN NUMBER IS
581: LN_EDUCATION_CESS NUMBER := 0;
582: LV_SOURCE_REGISTER_TYPE JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE;
583: CURSOR CUR_EDUCATION_CESS IS
584: SELECT
585: SUM(NVL(CREDIT
586: ,DEBIT))

Line 588: JAI_CMN_RG_OTHERS

584: SELECT
585: SUM(NVL(CREDIT
586: ,DEBIT))
587: FROM
588: JAI_CMN_RG_OTHERS
589: WHERE SOURCE_REGISTER_ID IN (
590: SELECT
591: RG23.REGISTER_ID
592: FROM

Line 674: JAI_CMN_RG_OTHERS

670: SELECT
671: SUM(NVL(CREDIT
672: ,-DEBIT))
673: FROM
674: JAI_CMN_RG_OTHERS
675: WHERE SOURCE_REGISTER_ID IN (
676: SELECT
677: REGISTER_ID
678: FROM