APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_OTH_BALANCES

Line 637: FROM JAI_CMN_RG_OTH_BALANCES

633: --WHERE nvl(rg23A_balance,0) + nvl(rg23c_balance,0) <> 0 ;
634:
635: CURSOR c_cess_balance (cp_org_unit_id number) is
636: SELECT SUM(balance)
637: FROM JAI_CMN_RG_OTH_BALANCES
638: WHERE org_unit_id = cp_org_unit_id
639: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980
640: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980
641: ln_cess_balance number :=0;

Line 646: FROM JAI_CMN_RG_OTH_BALANCES

642: /* Bug 4568078. Added by Lakshmi Gopalsami */
643:
644: CURSOR c_pla_cess_balance (cp_org_unit_id number) is
645: SELECT SUM(balance)
646: FROM JAI_CMN_RG_OTH_BALANCES
647: WHERE org_unit_id = cp_org_unit_id
648: AND register_type = jai_constants.reg_pla
649: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;
650:

Line 654: FROM JAI_CMN_RG_OTH_BALANCES

650:
651: --added by csahoo for bug#6109941, start
652: CURSOR c_sh_cess_balance (cp_org_unit_id number) is
653: SELECT SUM(balance)
654: FROM JAI_CMN_RG_OTH_BALANCES
655: WHERE org_unit_id = cp_org_unit_id
656: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)
657: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
658:

Line 663: FROM JAI_CMN_RG_OTH_BALANCES

659:
660:
661: CURSOR c_sh_pla_cess_balance (cp_org_unit_id number) is
662: SELECT SUM(balance)
663: FROM JAI_CMN_RG_OTH_BALANCES
664: WHERE org_unit_id = cp_org_unit_id
665: AND register_type = jai_constants.reg_pla
666: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;
667: