APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_BALANCES

Line 632: FROM JAI_CMN_RG_BALANCES;

628: nvl(rg23A_balance,0) + nvl(rg23c_balance,0) Balance ,
629: 'IO' party_type,
630: /* Bug 4568078. Added by LGOPALSA */
631: nvl(pla_balance,0) pla_balance
632: FROM JAI_CMN_RG_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)

Line 2216: FROM JAI_CMN_RG_BALANCES

2212: AND location_id = p_location_id ;
2213:
2214: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
2215: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance
2216: FROM JAI_CMN_RG_BALANCES
2217: WHERE organization_id = p_organization_id
2218: AND location_id = p_location_id ;
2219:
2220: v_pref_rg23a NUMBER;