APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_OTH_BALANCES

Line 238: FROM JAI_CMN_RG_OTH_BALANCES

234: --WHERE nvl(rg23A_balance,0) + nvl(rg23c_balance,0) <> 0 ;
235:
236: CURSOR c_cess_balance (cp_org_unit_id number) is
237: SELECT SUM(balance)
238: FROM JAI_CMN_RG_OTH_BALANCES
239: WHERE org_unit_id = cp_org_unit_id
240: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980
241: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980
242: ln_cess_balance number :=0;

Line 247: FROM JAI_CMN_RG_OTH_BALANCES

243: /* Bug 4568078. Added by Lakshmi Gopalsami */
244:
245: CURSOR c_pla_cess_balance (cp_org_unit_id number) is
246: SELECT SUM(balance)
247: FROM JAI_CMN_RG_OTH_BALANCES
248: WHERE org_unit_id = cp_org_unit_id
249: AND register_type = jai_constants.reg_pla
250: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;
251:

Line 255: FROM JAI_CMN_RG_OTH_BALANCES

251:
252: --added by csahoo for bug#6109941, start
253: CURSOR c_sh_cess_balance (cp_org_unit_id number) is
254: SELECT SUM(balance)
255: FROM JAI_CMN_RG_OTH_BALANCES
256: WHERE org_unit_id = cp_org_unit_id
257: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)
258: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
259:

Line 264: FROM JAI_CMN_RG_OTH_BALANCES

260:
261:
262: CURSOR c_sh_pla_cess_balance (cp_org_unit_id number) is
263: SELECT SUM(balance)
264: FROM JAI_CMN_RG_OTH_BALANCES
265: WHERE org_unit_id = cp_org_unit_id
266: AND register_type = jai_constants.reg_pla
267: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;
268: