DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_BALANCES

Line 221: FROM JAI_CMN_RG_BALANCES

217: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance,
218: NVL(basic_pla_balance,0) basic_pla_balance,
219: NVL(additional_pla_balance,0) additional_pla_balance,
220: NVL(other_pla_balance,0) other_pla_balance
221: FROM JAI_CMN_RG_BALANCES
222: WHERE organization_id = p_organization_id
223: AND location_id = p_location_id ;
224:
225: CURSOR ssi_unit_flag_cur(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS