create or replace PROCEDURE     ex_simple_select 
	( 
	inpVersionInd IN VARCHAR2, 
  outData IN OUT SYS_REFCURSOR
	)
AS   
	-- Add the varialbles for the stored procedure here
    sqlCommand VARCHAR2(4000);   
    val_app_code VARCHAR2(15);
    val_chg_ind NUMBER DEFAULT 1;
BEGIN
	-- Insert statements for procedure here
	IF (inpVersionInd IS NULL) THEN
    -- INTO val_app_code, val_chg_ind
    OPEN outData FOR
      SELECT apv.app_code, apv.db_chg_ind
        FROM mcs.app_version apv;
	ELSE
    -- INTO val_app_code, val_chg_ind
    OPEN outData FOR
      SELECT apv.app_code, apv.db_chg_ind 
        FROM mcs.app_version apv
        WHERE apv.db_chg_ind = val_chg_ind;
        --WHERE apv.db_chg_ind = inpVersionInd;
	END IF;
END ex_simple_select;