DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_BALANCES

Line 226: FROM JAI_CMN_RG_BALANCES

222: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance,
223: NVL(basic_pla_balance,0) basic_pla_balance,
224: NVL(additional_pla_balance,0) additional_pla_balance,
225: NVL(other_pla_balance,0) other_pla_balance
226: FROM JAI_CMN_RG_BALANCES
227: WHERE organization_id = p_organization_id
228: AND location_id = p_location_id ;
229:
230: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS